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 100 most common functions.

Did you enjoy this article? Get free email updates! Enter your email address here:

Delivered by FeedBurner

Today’s Shortcut: Insert New Worksheet in Excel

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

EasyExcel_27_Shortcut_Alt+Shift+F1


Other Shortcuts:

Download “Standard Keyboard” in Excel

Did you enjoy this article? Get free email updates! Enter your email address here:

Delivered by FeedBurner

Today’s Shortcut: Copy Cell Above

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

EasyExcel_24_Ctrl+D_Copy Cell above


Other Shortcuts:

Did you enjoy this article? Get free email updates! Enter your email address here:

Delivered by FeedBurner

Today’s Shortcut: Open Format Cells Dialog Box

EasyExcel_19_Format Cells Dialog Box

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

EasyExcel_19_Ctrl+1

Other Shortcuts:

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

Did you enjoy this article? Get free email updates! Enter your email address here:

Delivered by FeedBurner

Use a shortcut to switch between tabs in Excel

If you work with Excel all the time, you are probably pretty tired of switching between the tabs using the mouse. To make your life easier, learn this Excel keyboard shortcut:

  • Ctrl + PageUp
  • Ctrl + PageDown

EasyExcel_9_1


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

Did you enjoy this article? Get free email updates! Enter your email address here:

Delivered by FeedBurner