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=
- Select all the cells where you need autosum, one at a time using CTRL+Click
- Press ALT=
- 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.
9 Responses to “Autosum many ranges quickly with Multi-select & ALT= [quick tip]”
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
[…] This super slick tip comes from *THE* Excel guru himself – Chandoo. […]
Thanks for this, Chandoo - sometimes it's the simplest of tips that save us a lot of time. 🙂
Keep Updating....V.useful
Does this work with Excel 2007?
Alt + = does not seem to work for me.
Thank you!
Amazing & awesome.
very useful stuff
Hi Chandoo,
very useful tip.
Very Useful. Many Thanks!!!
Ultimate...Very useful trick
Thanks a million!!!