Instead of typing a SUM formula, an easier way to go is to use the shortcut Alt + Equal sign (=)
But did you know that you can use this shortcut for a whole table?
If you have a table like the one below, select all the values plus one extra row and one extra column:
READ MOREWe all know how to scroll one screen down in Word, Excel or almost any other application: Simply press the Page Down key. But in Excel we often want to scroll sideways too, and here’s how to do it:
Scroll one screen to the right: Alt + Page Down
Scroll one screen to the left: Alt + Page Up
Are you using a non-English version of Excel? Click here for translations of the 140 most common functions in 17 different languages:
Catalan
Czech
Danish
Dutch
Finnish
French
Galician
German
Hungarian
Italian
Norwegian
Polish
Portuguese (Brazilian)
Portuguese (European)
Russian
Spanish
Swedish
Turkish
This is a standard shortcut that works in most Windows applications, including all MS Office applications and all web browsers:
Hold down the Ctrl key and use the scroll wheel of your mouse to zoom in and out.
Of course, you can also use the zoom bar on the right bottom of the page, but when you know this shortcut you will probably never do that again!
Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.
If you want to create a new worksheet in an Excel workbook, you can use the mouse and click next to the rightmost existing sheet. But why not use a shortcut instead?
Alt + Shift + F1
Other Shortcuts:
In Excel you often want to copy the cell right above the active cell. Instead of the usual Copy-Paste routine, there is a keyboard shortcut in Excel which will make your life easier:
Ctrl + D
Other Shortcuts:
There is one dialog box I use more than any other: The Format Cells dialog box. You don’t want to use the mouse to click your way through the menus every time you need this box, so here’s the most important shortcut in Excel:
Open Format Cells Dialog Box: Ctrl + 1
Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.