Autosum many ranges quickly with Multi-select & ALT= [quick tip]
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=
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.
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
Leave a Reply
|Please join 50 ways to analyze data course to become an awesome analyst||“How Trump happened” in Excel [visualizations]|