Skip to content

Sum Multiple Columns in Excel at Once

This micro-article will give you a great shortcut that will save you a lot of time. In fact, you will learn how to sum the values in multiple columns in Excel with only a single keystroke.

The Keyboard Shortcut ALT + Equals

To calculate the sum for multiple columns in Excel at once, follow these two steps.

1 – Select the data you want to add up.

2 – Use the keyboard shortcut ALT + Equals (=).

And just like that, you have the total for each column of data.

This Works for Rows Too

If you want to sum the rows instead of columns, select all the data plus the cells in the column directly to the right of the data.

Now when you press ALT + Equals, you get total for each row.

How absolutely awesome is that!?

This Post Has 2 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top