Auto sum shortcut key in Microsoft Excel

Auto sum shortcut key in Microsoft Excel

Excel auto sum
             Microsoft Excel has been very important and essesness tool for routine office work. For making sum sub division or multiplumultip we need to use excel formulas..
    Here the short cut to create a Microsoft Excel formula to get the sum of all cells ias as bellow 
Select the cells you want to know the value of and pressing Alt and =(equals) together

Comments

Post a Comment

Popular posts from this blog

SOP - Postman Mobile Application-Android

Image
 SOP -  Postman Mobile Application-Android When you open the app after installing, the screen as shown  below appears. Please provide password. The default is  postman. After login, the postman will be provided the options to effect delivery of the following mail categories. Electronic Money Order, Speed Post, Registered Post, Parcel Post, Parcel COD, Bulk Delivery. The following are utility options to analyse delivery performance and tally account in case of eMO, COD articles etc. before submitting returns. Delivery Performance, Account, Barcode Scanner and Developer's Log The postman can select relevant options to deliver the mail items. For example to deliver the eMO he can click electronic money order icon. When Electronic Money Order is selected, all the eMO to be paid in the beat will appear as shown below. To pay the money order click take return option. This will bring the following screen which shows the details like article type, article no., name of the c...
Read more

HOW TO SUPPLY STAMPS TO BO FROM SO in SAP (CSI) ?

Image
SUPPLY STAMPS TO BO FROM SO in SAP (CSI) The procedure for supplying stamps from SO to BO for CSI Post offices   The entire process is divided into two parts              1.   Removing material from SO Location       2.   Placing material in to BO Location ===== Removing material from SO Location ===== Tcode : MIGO Select option “Remove from Storage” TF rem.fm str.toSLoc = “313” Doc header text : Perticular about sent stamps Material : RVS100 (For sending Revenue stamps, select other stamps as per necessity ) Plant : G131 Storaloc : SO CODE Destination : BO Code for whom stamp is to be sent Enter quntit Then press check and POST You will get document no (Send stamps with this document no to BO) ====== Placing stamps in BOs location =========== (This is to be done on the day when BO received actual stamps) Tcode : MIGO Action : Place in Storage Enter document no : Document no generated as above Press enter All the Stamp i...
Read more