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.