Excel shortcuts

15 Timesaving Tricks for Autosum in Excel

If you're like most people, you probably use the Autosum feature in Excel to quickly sum up a column or row of numbers. But did you know that there are a few tricks that can make Autosum even faster and easier to use? Here are 15 of them:

  1. To sum a column of numbers, simply select the cells in the column and press Alt + = (equal sign). Excel will automatically insert the SUM function for you.
  2. To sum a row of numbers, select the cells in the row and press Shift + Alt + =.
  3. To sum a range of cells, select the cells you want to sum and press Alt + =. Excel will automatically insert the SUM function for you.
  4. To sum only visible cells in a range, select the cells you want to sum and press Alt + Shift + =. This is useful if you have a range of cells that contains hidden values that you don't want to include in the sum.
  5. To sum all cells in a worksheet, press Alt + =. Excel will automatically insert the SUM function for you.
  6. To sum all cells in a worksheet that contain numbers, press Alt + Shift + =. This is useful if you have a worksheet that contains text and numbers, and you only want to sum the numbers.
  7. To sum all cells in a worksheet that contain values, press Alt + Ctrl + =. This is useful if you have a worksheet that contains text, numbers, and blank cells, and you only want to sum the cells that contain values.
  8. To sum all cells in a worksheet that contain formulas, press Alt + Shift + Ctrl + =. This is useful if you have a worksheet that contains text, numbers, and formulas, and you only want to sum the cells that contain formulas.
  9. To sum all cells in a worksheet that contain errors, press Alt + Shift + Ctrl + =. This is useful if you have a worksheet that contains text, numbers, and errors, and you only want to sum the cells that contain errors.
  10. To sum all cells in a worksheet that contain text, press Alt + Shift + Ctrl + =. This is useful if you have a worksheet that contains text, numbers, and text, and you only want to sum the cells that contain text.
  11. To sum all cells in a worksheet that contain numbers, press Alt + Shift + Ctrl + =. This is useful if you have a worksheet that contains text, numbers, and numbers, and you only want to sum the cells that contain numbers.
  12. To sum all cells in a worksheet that contain dates, press Alt + Shift + Ctrl + =. This is useful if you have a worksheet that contains text, numbers, and dates, and you only want to sum the cells that contain dates.
  13. To sum all cells in a worksheet that contain time values, press Alt + Shift + Ctrl + =. This is useful if you have a worksheet that contains text, numbers, and time values, and you only want to sum the cells that contain time values.
  14. To sum all cells in a worksheet that contain non-numeric values, press Alt + Shift + Ctrl + =. This is useful if you have a worksheet that contains text, numbers, and non-numeric values, and you only want to sum the cells that contain non-numeric values.
  15. To sum all cells in a worksheet that contain formulas, press Alt + Shift + Ctrl + =. This is useful if you have a worksheet that contains text, numbers, and formulas, and you only want to sum the cells that contain formulas.
  16. To sum all cells in a worksheet that contain errors, press Alt + Shift + Ctrl + =. This is useful if you have a worksheet that contains text, numbers, and errors, and you only want to sum the cells that contain errors.

As you can see, there are a few tricks that can make Autosum even faster and easier to use. Give them a try the next time you need to sum a column or row of numbers 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.