Excel Worksheet Movement Keys

Excel Worksheet Movement Keys

Key Action

Up arrow ( ↑) : Moves the active cell up one row
Down arrow (↓) : Moves the active cell down one row
Left arrow (←) : or Shift+Tab Moves the active cell one column to the left
Right arrow (→) : or Tab Moves the active cell one column to the right
PgUp : Moves the active cell up one screen
PgDn : Moves the active cell down one screen
Alt+PgDn : Moves the active cell right one screen
Alt+PgUp : Moves the active cell left one screen
Ctrl+Backspace : Scrolls the screen so that the active cell is visible
↑   : Scrolls the screen up one row (active cell does not change)
↓   : Scrolls the screen down one row (active cell does not change)
← : Scrolls the screen left one column (active cell does not change)
→ : Scrolls the screen right one column (active cell does not change)

Ribbon tabs

The commands available in the Ribbon vary, depending upon which tab is selected. The
Ribbon is arranged into groups of related commands. Here’s a quick overview of Excel’s tabs:
■ Home:
You’ll probably spend most of your time with the Home tab selected. This
tab contains the basic Clipboard commands, formatting commands, style com-
mands, commands to insert and delete rows or columns, plus an assortment of
worksheet editing commands.

■ Insert:
Select this tab when you need to insert something into a worksheet — a
table, a diagram, a chart, a symbol, and so on.

■ Page Layout: 
This tab contains commands that affect the overall appearance of
your worksheet, including some settings that deal with printing.

■ Formulas:
Use this tab to insert a formula, name a cell or a range, access the for-
mula auditing tools, or control the way Excel performs calculations.

■ Data:
Excel’s data-related commands are on this tab, including data validation
commands.

■ Review:
This tab contains tools to check spelling, translate words, add comments,
or protect sheets.

View:
The View tab contains commands that control various aspects of how a sheet
is viewed. Some commands on this tab are also available in the status bar.

■ Developer:
This tab isn’t visible by default. It contains commands that are use-
ful for programmers. To display the Developer tab, choose File ➪ Options and then
select Customize Ribbon. In the Customize the Ribbon section on the right, make
sure Main Tabs is selected in the drop-down control, and place a check mark next
to Developer.

■ Add-Ins:

This tab is visible only if you loaded an older workbook or add-in that

customizes the menu or toolbars. Because menus and toolbars are no longer avail-
able in Excel 2016, these user interface customizations appear on the Add-Ins tab.