AutoSum in Excel (Shortcut) 

Adding all the values in a column or a row and getting the sum of it is a common task for many Excel users.

While this can be done using the sum function, let me show you a shortcut to AutoSum in Excel to do this much faster.

You can use the shortcut to get the sum of values in a column as well as rows.

Shortcut to AutoSum in Excel

Below is the shortcut to auto-sum in Excel for Windows:

ALT + =

And if you’re using a Mac, you can use the below shortcut:

Command + Shift + T

How to Use the Keyboard Shortcut to AutoSum in Excel

Below are the steps to use the above keyboard shortcut to AutoSum a selected column:

  1. Select the column for which you want to sum the values
  2. Use the above keyboard shortcut ALT + = (hold the ALT key and then press the equal-to key)
Autosum Column excel

In the above screenshot, I have shown you how to auto-sum values in a column, but you can do the same thing with a row as well (as shown below).

autosum row in Excel

In case you have the data across multiple columns, you can select all the columns and then use the above keyboard shortcut and it is going to give you the auto sum at the end of each column (as shown below)

autosum multiple columns in Excel

Important Things to Know About AutoSum in Excel:

  • When you use the keyboard shortcut to get the autosum, it inserts the sum formula at the end of the column/row. so if you change any data point in the cells, the formula will automatically update to reflect the new sum
  • The above autosum shortcut would not work with non-contiguous columns or rows. For this to work, your selection has to be continuous.
  • In case there are any text values in the column that you’re trying to sum, using the above shortcut would give you the auto sum of all the numeric values while ignoring the text values

Other Excel shortcuts you may also like:

Other Excel Tutorials You May Also Like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment