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:


quick-autosumHow 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.


Written by Chandoo
Tags: , , , , ,
Home: 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.

  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!!!

Leave a Reply