How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.

How to highlight individual values in Excel The simple data set shown in Figure A repeats a few values in column D: 1, 2, and 6. They’re easy to discern visually, but that won’t always be the ...

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.

Place your text cursor in the formula field at the top of the window. Fill in the formula field with "SUM(A:A)" and replace "A:A" with the indefinite range you want to total.