Use Excel’s AutoSum button to add up rows and columns with just one click Want to quickly add up rows or columns of data in your gradebook (or elsewhere)? The AutoSum function makes it easy.

2. Use the AutoSum function This is the most common function used in Excel. This is widely used in spreadsheets, especially when it comes to summing up sales or other figures. Just highlight the ...

When you click Excel's AutoSum button (the one in the toolbar that looks like Σ) from a cell next to a row or column of numbers, Excel automatically sums those numbers.

Shaun from Spreadsheet Point discusses the Format Painter button, the F4 key, Flash Fill, AutoSum, the fastest way to remove duplicates, and advanced conditional formatting techniques.