Excel shortcuts

The 5 Best AutoSum Shortcuts in Excel for Mac

If you're an Excel user, chances are you've used the AutoSum feature to quickly sum a range of cells. AutoSum is a great time-saver, but did you know there are a few shortcuts that can make using it even faster and easier? Here are the five best AutoSum shortcuts in Excel for Mac:

  1. To select a range of cells to sum: Simply click and drag your mouse over the cells you want to sum. AutoSum will automatically detect the range and sum the cells for you.
  2. To sum only visible cells: If you have a filtered range of cells and you only want to sum the visible cells, simply press Option + =. AutoSum will automatically sum only the visible cells in the range.
  3. To sum a column or row of cells: To sum an entire column or row of cells, simply click on the cell at the end of the column or row you want to sum. Then press Option + =. AutoSum will automatically sum the entire column or row for you.
  4. To sum a range of cells that's not adjacent: To sum a range of cells that's not adjacent, simply click on the first cell in the range, then press and hold Shift while you click on the last cell in the range. Then press Option + =. AutoSum will automatically sum the entire range for you.
  5. To sum a range of cells that's not in a row or column: To sum a range of cells that's not in a row or column, simply click on the first cell in the range, then press and hold Command while you click on the last cell in the range. Then press Option + =. AutoSum will automatically sum the entire range for you.

These are just a few of the many shortcuts you can use with AutoSum in Excel for Mac. Experiment with different combinations of keys and see what other time-saving shortcuts you can discover!

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.