Topics Map > Office 365 > Excel
Microsoft Excel - Excel Online keyboard shortcuts
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 (,).
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. 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, downward Shift+F4 Repeat Find, upward Ctrl+Shift+F4 Insert chart Alt+F1 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. 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 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 Insert function Shift+F3 Increase font size Ctrl+Shift+> Decrease font size Ctrl+Shift+< 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 line Home Go to end of cell line 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 Paste formatting Shift+Ctrl+V 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 (28 rows) Page Down Move up one screen (28 rows) Page Up 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. Insert new sheet Shift+F11 Switch to next sheet Alt+Control+Page Down Switch to previous sheet Alt+Control+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 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 Auto Sum Alt+Equals (=)Quick tips for using keyboard shortcuts with Excel Online
Frequently used shortcuts
Access keys: Shortcuts for using the ribbon
Shortcuts for Excel Online commands in Editing view