How to AutoSum Multiple Ranges in Excel using ALT Key and Multi-Select

Shortcut keys are useful when you are working with Ms-Excel or any other application. Using a combination of keyboard shortcuts, you can quickly execute a function or insert a table etc. Here in this post, I’ll show you how to AutoSum multiple ranges in Excel using multi-select along with the Alt key.

A Scenario

Here’s a simple scenario. I have an Excel worksheet with multiple figures for various "Months", scattered all over the sheet. I want to see the sum of all the figures or values below each month with the press of few buttons, without manually writing the =SUM() function below the figures. See the image below.

The "arrows" in the image shows where I want to show the sum of the figures.

How do I do it?

We will first multi-select the boxes below each month’s figures.

1) To multi-select boxes, hold the Ctrl key and click each box (where you wish to show the sum) using the mouse. (Ctrl+Click)

2) Once you have selected the boxes, leave the Ctrl key the press Alt and = keys simultaneously. (Alt =)

Similar example: How to Find Duplicates in Excel using Conditional Formating

The Alt= key combination will automatically add the =sum() function below each months figures, along with a range. For example, for the first column in the above example, the range would be =SUM(A2:A4).

Output

← PreviousNext →