Keyboard shortcuts in Excel Online

The keyboard shortcuts that are described in this Help topic refer to the U.S. keyboard layout. Keys on other layouts might not correspond exactly to the keys on a U.S. keyboard.

For an overview of accessibility in Excel Online see Accessibility features in Excel Online.

Quick tips for using keyboard shortcuts with Excel Online

  • If a shortcut requires pressing two or more keys at the same time, this topic separates the keys with a plus sign (+). If you have to press one key immediately after another, the keys are separated by a comma (,).

  • Excel Online runs in your web browser so the keyboard shortcuts are different than those in the Excel desktop program. For example, you'll use Ctrl+F6 instead of F6 for jumping in and out of the commands. Also, common shortcuts like F1 and Ctrl+P apply to the web browser, not Excel Online.

  • As a shortcut to commands, press Alt+Q to jump to Tell Me, and then type the command you want (available only in Editing view). Use the Up and Down arrows to select a command, and then press Enter.

  • To jump to a particular cell, use the Go To command: press Ctrl+G, type the cell reference (such as B14), and then press Enter.

  • Keyboard shortcuts in Excel Online are very similar to keyboard shortcuts in Microsoft Excel. For a list of keyboard shortcuts in other versions, see More Excel keyboard shortcuts.

  • If you use a screen reader, see Common tasks in Excel Online.

These are the most frequently used shortcuts for Excel Online.

To do this

Press

Go to a cell

Ctrl+G

Move down

Page down or Down Arrow

Move up

Page up or Up Arrow

Print

Ctrl+P

Copy

Ctrl+C

Paste

Ctrl+V

Cut

Ctrl+X

Undo

Ctrl+Z

Close workbook

Ctrl+W

Find

Ctrl+F

Bold

Ctrl+B

Open context menu

  • Windows keyboard: Windows context key+F10. The Windows context key is between the Left Alt key and the Left Ctrl key

  • Other keyboard: Shift+F10

Tell me

Alt+Q

Find

Ctrl+F or Shift+F3

Repeat Find down

Shift+F4

Repeat Find up

Ctrl+Shift+F4

If a spreadsheet opens in Excel Online Read view, editing commands won’t work. To switch to Edit view, move the focus out of the worksheet by pressing F6 or Ctrl+F6, and then tab to the Edit Workbook list. Press Spacebar, press the Down Arrow key, and then select Edit in Excel Online.

To do this

Press

Move between ribbon and workbook content

Ctrl+F6

Move to a different ribbon tab

Tab and then Enter

Move among commands on a ribbon

Tab

Execute the currently selected ribbon command

Enter

Go to the beginning of the row

Home

Go to cell A1

Ctrl+Home

Go to the last cell of used range

Ctrl+End

Move down one screen

Page Down

Move up one screen

Page Up

Move within a selected range from top to bottom (or forward through selection)

Enter

Move within a selected range from bottom to top (or back through selection)

Shift+Enter

Move within a selected range forward through a row (or down through a single-column selection)

Tab

Move within a selected range back through a row (or up through a single-column selection)

Shift+Tab

To do this

Press

Up one cell

Up Arrow, or Shift+Enter

Down one cell

Down Arrow, or Enter

Right one cell

Right Arrow, or Tab

Left one cell

Left Arrow, or Shift+Tab

Go to A1

Ctrl+Home

Last cell of used range

Ctrl+End

Move down one screen

Page Down

Move up one block of rows

Page Up

To do this

Press

Open menu/Drill down

Alt+Down Arrow

Drill up

Alt+Up Arrow

Follow hyperlink

Ctrl+Enter

Open Comment pane

Shift+F2

To do this

Press

Select a range of cells

Shift+Arrow keys

Select an entire column

Ctrl+SPACE

Select a Entire row

Shift+SPACE

Go to beginning of row

Shift+Home

Move up block of cells in current column

Shift+Page Up

Move down block of cells in current column

Shift+Page Down

To do this

Press

From top to bottom (or forward through selection)

Enter

From bottom to top (or back through selection)

Shift+Enter

Forward through a row (or down through a single-column selection)

Tab

Back through a row (or up through a single-column selection)

Shift+Tab

To do this

Press

Calculate workbook (refresh)

F9

Full calculate

Ctrl+Shift+Alt+F9

Refresh external data

Alt+F5

Refresh all external data

Ctrl+Alt+F5

To do this

Press

Cut

Ctrl+X

Copy

Ctrl+C

Paste

Ctrl+V

Undo

Ctrl+Z

Redo

Ctrl+Y

Start a new line in the same cell

Alt+Enter

Insert hyperlink

Ctrl+K

Insert Table

Ctrl+L

To do this

Press

Complete cell entry and select the cell below

Enter

Complete cell entry and select the cell above

Shift+Enter

Complete cell entry and select the next cell in the row

Tab

Complete cell entry and select the previous cell in the row

Shift+Tab

Cancel cell entry

Esc

To do this

Press

Edit selected cell

F2

Clear selected cell

Delete

Clear selected cell and start editing

Backspace

Move right one character

Right Arrow

Move left one character

Left Arrow

Move right one word

Ctrl+Right Arrow

Move left one word

Ctrl+Left Arrow

Go to beginning of cell data

Home

Go to end of cell data

End

Select right by character

Shift+Right Arrow

Select left by character

Shift+Left Arrow

Select right by word

Shift+Ctrl+Right Arrow

Select left by word

Shift+Ctrl+Left Arrow

Select to beginning of cell data

Shift+Home

Select to end of cell data

Shift+End

Copy

Ctrl+C

Cut

Ctrl+X

Paste

Ctrl+V

To do this

Press

Bold

Ctrl+B

Italics

Ctrl+I

Underline

Ctrl+U

More Excel keyboard shortcuts

Keyboard shortcuts in Excel Online are very similar to keyboard shortcuts in Microsoft Excel. The keyboard shortcuts listed in this article are for the most common tasks in Excel Online. For a list of keyboard shortcuts in your Excel desktop program, see:

Common tasks in Excel Online

For steps to accomplish particular tasks in Excel Online, see the following articles:

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×