Keyboard shortcuts in Excel Online

This article describes keyboard shortcuts for Excel Online.

Notes: 

  • These shortcuts refer to the U.S. keyboard layout. Keys on other layouts might not correspond exactly to the keys on a U.S. keyboard.

  • 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 (,).

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

In this article

Quick tips for using keyboard shortcuts with Excel Online

  • 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 to move to regions in the app.

    You can use common browser shortcuts like F1 and Ctrl+

  • You can find any command quickly by pressing Alt+Win+Q to jump to Tell Me, In Tell Me, you can just type a word or the name of a command you want (available only in Editing view). Tell Me searches for related options, and provides a list. Use the Up and Down arrows to select a command, and then press Enter.

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

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

Frequently used shortcuts

These are the most frequently used shortcuts for Excel Online.

To do this

Press

Go to a specific 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, ddownward

Shift+F4

Repeat Find, uupward

Ctrl+Shift+F4

Access keys: Shortcuts for using the ribbon

Excel Online now offers access keys, keyboard shortcuts to navigate the ribbon. If you’ve used access keys to save time on Excel for desktop computers, you’ll find access keys very similar in Excel Online.

In Excel 2016 for Windows, access keys start with the Alt key. In Excel Online, access keys all start with Alt+Win, then add a letter for the ribbon tab. For example, to go to the Review tab, press Alt+Win+R.

ExcelOnline ribbon showing Home tab and KeyTips on all tabs
  • To get to the ribbon, press Alt+Win, or press Ctrl+F6 until you reach the Home tab

  • To move between tabs on the ribbon, press the Tab key.

  • To hide the ribbon so you have more room to work, press Ctrl+F1. Repeat to display the ribbon again.

To go directly to a tab on the Ribbon, press one of the following access keys:

To do this

Press

Open the Tell Me box on the ribbon and type a search term.

Alt+Win+Q

Open the File tab and use the Backstage view

Alt+Win+F

Open the Home tab and format text and numbers, or use other tools such as Find.

Alt+Win+H

Open the Insert tab and insert a function, table, chart, hyperlink, or comment.

Alt+Win+N

Open the Data tab and refresh connections or use data tools.

Alt+Win+A

Open the Review tab and use the Accessibility Checker or work with comments.

Alt+Win+R

Open the View tab to choose a view, freeze rows or columns in your worksheet, or show gridlines and headers

Alt+Win+W

The shortcuts in this table can save time when you work with the ribbon tabs and ribbon menus

To do this

Press

Select the active tab of the Ribbon, and activate the access keys.

Alt +Win. To move to a different tab, use an access keys or the Tab key.

Move the focus to commands on the Ribbon.

Enter, then Tab or Shift+Tab

Activate a selected button.

Spacebar or Enter

Open the list for a selected command

Spacebar or Enter

Open the menu for a selected button.

Alt + Down Arrow

When a menu or submenu is open, move to the next command.

Esc

Shortcuts for Excel Online commands in Editing view

If a spreadsheet opens in Excel Online Reading view, editing commands won’t work. To switch to Edit view, move the focus out of the worksheet by pressing 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

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

Go to beginning of cell data

Home

Go to end of cell data

End

Select right by character

Shift+Right Arrow

Select to beginning of cell data

Shift+Home

Select to end of cell data

Shift+End

Select left by character

Shift+Left Arrow

Extend selection to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell.

Ctrl+Shift+Right Arrow or Ctrl+Shift+Left Arrow

To do this

Press

Bold

Ctrl+B

Italics

Ctrl+I

Underline

Ctrl+U

To do this

Press

Up one cell

Up Arrow, or Shift+Enter

Down one cell

Down Arrow, or Enter

Move right one cell

Right Arrow, or Tab

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 up block of cells in current column

Shift+Page Up

Move down one screen

Page Down

Move down block of cells in current column

Shift+Page Down

Move to the edge of the current data region

Ctrl+Right Arrow or Ctrl+Left Arrow

Move between ribbon and workbook content

Ctrl+F6

Move to a different ribbon tab

Tab.

Press Enter to go to the ribbon for that tab.

To do this

Press

Open menu/Drill down

Alt+Down Arrow

Drill up

Alt+Up Arrow

Follow hyperlink

Ctrl+Enter

Open Comment pane while editing

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

Extend selection to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, to the next nonblank cell.

Ctrl+Shift+Right Arrow or Ctrl+Shift+Left Arrow

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

Enter or exit a content Add-in

  • To enter a content Add-in, press Enter, and then press the Tab key to move within the Add-in.

  • To exit the Add-in, press Esc.

See Also

For steps to accomplish particular tasks in Excel Online by using keyboard shortcuts and a screen reader, see the following articles:

For more information about support for accessibility, see Office Accessibility Center.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×