When you're building your worksheets, it's best to have your formulas and functions in place, so that as soon as you start adding records, your counts, sums, and other calculations get right to work.
Because I don't know how many registrations I'll get for this event, I can't forecast how many cells to include in this sum of the Amount Paid column.
This isn't a problem, however, because I can sum the whole column, all the way down to the 1,048.576th row, with just a click and a keyboard shortcut.
So I start my sum as usual, and then I click in the first cell that will contain registration amounts in the worksheet.
Then, rather than dragging down to select the range, I just press CtrL + the down arrow, and the whole column is selected.
I type the closing parenthesis, and press Enter, and the formula is created.
To test it, I just type a few numbers in the cells, and we see the total update.
Easy!
How to Learn Excel
Master Excel with hands-on training. Excel is the leading spreadsheet application used by over 750 million people worldwide.
