Excel Keyboard Shortcuts – Navigation

Save time by moving around an Excel spreadsheet without having to take your hands off the keyboard and move back and forth between it and the mouse.

Keyboard Shortcuts

Key

or * = Hold this key down while tapping the white keys in sequence indicated.

= Tap this key(s) in sequence indicated (if there is more than one) whilst holding down the grey key.

Keyboard Shortcuts

Go to end of column/row

Starting from a blank cell, active cell becomes next filled cell in that direction.

Starting from a filled cell, active cell becomes the last filled cell in that direction (until a blank cell is reached).

Starting from last filled cell in that direction, skips blank cells to next filled cell or goes to end of spreadsheet

CTRL* +
Arrow Keys


Held down Control button Down arrow key

OR

END + Arrow Keys

END shortcut key for Excel Down arrow key

Starting Position
Move to end of row or column with CTRL + arrow keys
After CTRL + Down Arrow

Go To cell A1

CTRL* + Home


Held down Control button Home key shortcut in Excel

Starting Position
CTRL + Home takes you back to cell A1
After CTRL + HOME

Move 1 cell right

TAB


Moving around Excel worksheet using the TAB key

Starting Position
the tab key moves you one cell right
After TAB

Move 1 cell left

SHIFT* + TAB


Holding SHIFT button in Excel Moving around Excel worksheet using the TAB key

Starting Position
Use the keyboard to move 1 cell left
After SHIFT* + TAB

Move 1 cell down

RETURN (or ENTER)


Navigating a spreadsheet using the keyboard

Starting Position
Use RETURN key to move 1 cell down
After RETURN

Move 1 cell up

SHIFT* + RETURN (or ENTER)


Holding SHIFT button in Excel Navigating a spreadsheet using the keyboard

Starting Position
SHIFT + RETURN moves 1 cell up.
After SHIFT* + RETURN

Move 1 worksheet right

CTRL* + Page Down


Holding down CTRL button for spreadsheet navigation Moving around a spreadsheet using Page Down button

Starting Position
Move between worksheets using the keyboard
After CTRL* + Page Down

Move 1 worksheet left

CTRL* + Page Up


Holding down CTRL button for spreadsheet navigation Moving between worksheets using CTRL and PAGE UP

Using CTRL + Page Down to move between Excel worksheets
Starting Position
CTRL + Page Down moves you one worksheet left.
After CTRL* + Page Up

Other Excel Keyboard Shortcuts

  1. Selection
  2. Inserting
  3. Deleting
  4. Values
  5. Office Keyboard Shortcuts

Other Excel Help

Follow our blog which has loads of Excel Tips.

Our Business Spreadsheets page offers complementary spreadsheet downloads demonstrating useful Excel techniques to help you in the office.

Comments are closed.