Excel shortcuts

The Excel sum formula shortcut that will save you time

If you're like most people, you probably use the SUM function in Excel all the time. And if you're like most people, you probably don't know about a little shortcut that can save you a lot of time when using the SUM function.

Here's the thing...

The SUM function in Excel is really just a shortcut for adding up a range of cells. So, for example, if you wanted to add up the cells in column A from row 1 to row 10, you could use the following formula:

=SUM(A1:A10)

However, there's a much easier way to do this. Instead of using the SUM function, you can simply select the range of cells you want to add up, and then press the F9 key. This will automatically insert the SUM function into the cell, with the range of cells you selected as the argument.

So, using the example above, if you selected cells A1:A10 and pressed F9, the following formula would be inserted into the cell:

=SUM(A1:A10)

Pretty nifty, right?

There's one other thing to keep in mind when using this shortcut. If you have a cell that already contains a formula, pressing the F9 key will simply insert the formula into the cell without adding up the cells. So, if you want to add up the cells and also keep the existing formula, you'll need to press the Shift + F9 keys instead.

That's all there is to it! This little shortcut can save you a lot of time when adding up ranges of cells in Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.