Today’s shortcut: Scroll sideways with PageUp and PageDown in Excel

We 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

EasyExcel_44_Scroll_sideways

More shortcuts in Excel:

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

Today’s Shortcut: Zoom in and Zoom out in Excel

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!

EasyExcel_40_Zoom in and our in Excel

More shortcuts in Excel:



Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.

Hide or show Ribbon in Excel

The ribbon in Excel, which was introduced in Excel 2007, is a major improvement from the old menus. But it takes up a lot of space, so sometimes you want to hide it. There are several ways to do it, but all you have to learn is the shortcut:

Hide ribbon: Ctrl + F1

Show ribbon: Ctrl + F1

Easy-Excel_5_1

This also works in Word, Powerpoint and Outlook 2007 and later


Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.