Excel shortcuts

How to Use the Auto Sum Shortcut in Excel

If you're like most people, you probably use the Auto Sum shortcut in Excel all the time. But did you know that there's a faster way to do it?

Here's how:

1. Select the cell where you want the sum to appear.

2. Type =SUM(

3. Select the cells you want to sum, then press Enter.

That's it! The sum will appear in the cell you selected in step 1.

Here's a tip: You can also use the Auto Sum shortcut to sum a range of cells that are not adjacent to each other. Just select the first cell in the range, then hold down the Shift key while you select the last cell in the range. Then type =SUM( and press Enter.

You can also use the Auto Sum shortcut to sum a column or row of cells. Just select the first cell in the column or row, then hold down the Ctrl key while you select the last cell in the column or row. Then type =SUM( and press Enter.

That's all there is to it!

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.