Navigation

 

Across Excel      

Shortcut

Description

F6

Switches between the worksheet, ribbon, task pane and Zoom controls.

 

For a split worksheet, it includes the split panes.

SHIFT+F6

Switches between the worksheet, Zoom, task pane and ribbon

 

Across Workbooks

Shortcut

Description

CTRL+Tab or CTRL+F6

Switch to the next open workbook window, if available

CTRL+SHIFT+Tab

Switch to previous open workbook window, if available

 

Across Worksheets in a Workbook

Shortcut

Description

CTRL+Page Down

Move and activate next worksheet

CTRL+Page Up

Move and activate previous worksheet

SHIFT+F11 or Alt+Shift+F1

Insert a new worksheet to left of the active worksheet

 

Across Cells

Shortcut

Description

TAB or ARROW RIGHT

Move one cell to the right

 SHIFT+TAB or ARROW LEFT

Move one cell to the left

ARROW UP or ARROW DOWN

Move one cell up or down

 CTRL+ARROW RIGHT

Move to the last occupied cell in row of data block

CTRL+ARROW LEFT

Move to the first occupied cell in row of data block

 CTRL+ARROW UP

Move to the first occupied cell in column of data block

CTRL+ARROW DOWN

Move to the last occupied cell in column of data block

CTRL+END

Move to the last / bottom occupied cell of data block

CTRL+HOME

Move to the cell A1

CTRL+.

Move clockwise to the next corner of selected range

ALT+PAGE DOWN

Moves one screen to the right in a worksheet

ALT+PAGE UP

Moves one screen to the left in a worksheet

 

Find, Replace and GoTo

Shortcut

Description

CTRL+F

Open Find dialog box

SHIFT+F4

Find Next

SHIFT+F5

Find a value

CTRL+H

Open Replace dialog box

CTRL+G or F5

Open GoTo Dialog

 

Help

Shortcut

Description

F1

Displays the Help file task pane

F10 or ALT

Turns key tips on or off

ALT+SHIFT+F10

Displays the menu or message for an Error checking button

 

Menu

Shortcut

Description

SHIFT+F10

Show Right Click Menu

F10, CTRL+F10

Activate the Menu Bar

CTRL+F1

Displays / Hides the Ribbon

 

Window

Shortcut

Description

CTRL+F7

Performs the Move command on the workbook window when it is not maximized. Use arrows and then ENTER to confirm or ESC to cancel

CTRL+F5

Restores the window size of the selected workbook window

CTRL+F6

Next workbook window

CTRL+SHIFT+F6

Previous workbook window

CTRL+F9

Minimize workbook

CTRL+F8

Performs the Size command on the Control menu for the workbook window when a workbook is not maximized

CTRL+F10

Maximizes or restores the selected workbook window

 

Pane

Shortcut

Description

F6

Move next pane

SHIFT+F6

Move previous pane

 

VBA Editor

Shortcut

Description

CTRL+PGUP

Go to top of current procedure in another sheet

CTRL+PGDOWN

Go to top of current procedure in another sheet

CTRL+HOME

Top of Module

CTRL+END

End of Module

CTRL+ARROW LEFT

Move one word to the left

CTRL+ARROW RIGHT

Move one word to the right

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017