Note that this shortcut works on Excel for Mac and PC 2016. All you have to do is enter the formula in the first row.Īutosum works on both rows and columns. Autosum can be a really neat time saver in Excel. For example to get the difference between 800 AM – 1200 PM for payroll purposes you would use.įind the sum of the selected cells on the Status bar use AutoSum in Excel to sum all or only filtered cells employ the SUM function or convert your range to Table for easy calculations. If youre just getting started with Excel this is a great way to get up to speed with the basic use of Functions. Excels AutoSum feature is a great shortcut that automatically creates a formula with the SUM function.įor example pressing Ctrl1 will open the Format Cells Window Dialog Box. The Autosum Excel shortcut is very simple just type two keys. Select a cell next to the numbers you want to sum click AutoSum on the Home tab press Enter and youre done.
Its pretty smart at figuring out the range we want to sum up.īasic Microsoft Excel Formulas Cheat Sheets Keyboard Shortcut Keys Hacks Excel Formula Microsoft Excel Formulas Computer Shortcut Keys How do I add or subtract Times.
