Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How AutoSum Shortcut works in Excel?

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 272

PostPosted: Sun Jan 22, 2017 4:03 pm    Post subject: How AutoSum Shortcut works in Excel? Reply with quote

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





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





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.





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()





Select your range (in this case A1:A3)





Press Enter. You have the sum.






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.





Do these practises even for fun, it makes you an Excel Master Smile


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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group