How AutoSum Shortcut works in Excel?

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 291
Joined: Tue Sep 25, 2007 12:41 pm

How AutoSum Shortcut works in Excel?

Post by Admin » Sun Jan 22, 2017 4:03 pm

If you want to make a quick sum of a range of data, the best and easiest way is to use the shortcut for Autosum.

First, you need to install it in your quick access toolbar. So follow the steps:

Right mouse click on the Autosum button (Σ button under Home tab) > select Add to Quick Access Toolbar


Image


The Autosum ( Σ ) tool is now added to the tiny toolbar above the Home tab.


Image


Now press Alt on your keybord > it shows you the number of your new shortcut key (here it is 4) > so your Autosum shortcut combination is Alt+4.


Image


By the way, if you press Alt again, the numbers will disappear.


So the shortcut key is installed.



Now try a calculation:

In Column A, I have the numbers to sum up. I want the calculation in cell B4.

Select cell B4 (or any cell where you wan to do the sum) > press Alt+4. It will show you =SUM()


Image


Select your range (in this case A1:A3)


Image


Press Enter. You have the sum.


Image



If for any reason, you would like to remove the Ausum ahortcut from the tiny toolbar, where you just added it, then right mouse click on it > select Remove from Quick Access Toolbar. It will be removed immediately.


Image


Do these practises even for fun, it makes you an Excel Master :-)


By the way, I am using Excel 2007.





*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.

For comments of suggestions, please contact us: info@shamskm.com

Post Reply