Autosum many ranges quickly with Multi-select & ALT= [quick tip]

Posted on February 26th, 2016 in Keyboard Shortcuts , Learn Excel - 9 comments

Let’s say you have data in a worksheet in various ranges, and you want sum up each range at the bottom.

Something like this:

How to do all this one shot?

Simple. We use multi-select & ALT=

1. Select all the cells where you need autosum, one at a time using CTRL+Click
2. Press ALT=
3. Done!

See the demo aside.

Do more with CTRL

If you think multi-select is only useful for bulk formattting, think again. Here are few awesome CTRL+Click tricks. (Say that again three times quickly.)

Note: We discussed a similar problem almost 2.5 years ago here – Sporadic totals in Excel.

 Please join 50 ways to analyze data course to become an awesome analyst “How Trump happened” in Excel [visualizations]
 Written by Chandoo Tags: autosum, keyboard shortcuts, Learn Excel, Microsoft Excel Formulas, quick tip, screencasts Home: Chandoo.org Main Page ? Doubt: Ask an Excel Question

9 Responses to “Autosum many ranges quickly with Multi-select & ALT= [quick tip]”

1. Puneet Gogia says:

Very Nice Tip Chandoo.

As it is very useful but it also look smart.

You can select these cells without using Ctrl key.

http://goo.gl/myZFZM

2. […] This super slick tip comes from *THE* Excel guru himself – Chandoo. […]

3. Nikki says:

Thanks for this, Chandoo - sometimes it's the simplest of tips that save us a lot of time. 🙂

4. Darshan says:

Keep Updating....V.useful

5. Irene says:

Does this work with Excel 2007?
Alt + = does not seem to work for me.

Thank you!

6. Kapil says:

Amazing & awesome.

very useful stuff

7. Raja Aurongzeb says:

Hi Chandoo,
very useful tip.

8. Laxmikant Borde says:

Very Useful. Many Thanks!!!

9. Kutubuddin says:

Ultimate...Very useful trick
Thanks a million!!!

 Please join 50 ways to analyze data course to become an awesome analyst “How Trump happened” in Excel [visualizations]