https://hkeys.app

Microsoft Excel Keyboard Shortcuts for Web

Microsoft Excel Online Keyboard Shortcuts. View hotkeys online or download free PDF Cheat Sheet to work faster with spreadsheets in Excel web version.

Show table of contentsPrint shortcutsSign in to download the PDF It takes a few seconds.
Sign in → Sign in to save this shortcuts set to favorites.
Sign in →
Key label style

Frequently used shortcuts

Go to a specific cell
Ctrl+G
Move down
Pg Dn
or
Down
Move up
Pg Up
or
Up
Print a workbook
Ctrl+P
Copy selection
Ctrl+C
Paste selection
Ctrl+V
Cut selection
Ctrl+X
Undo action
Ctrl+Z
Open workbook
Ctrl+O
Close workbook
Ctrl+W
Open the Save As dialog box
Alt+F2
Use Find
Ctrl+F
or
Shift+F3
Apply bold formatting
Ctrl+B
Open the context menu
Shift+F10
or
Context Menu
Jump to Search or Tell me
Alt+Q
Repeat Find downward
Shift+F4
Repeat Find upward
Ctrl+Shift+F4
Insert a chart
Alt+F1
Display the access keys (ribbon commands) on the classic ribbon when using Narrator
Alt+.

Go to the access keys for the ribbon

Go to the Search or Tell Me field on the ribbon and type a search term
Win+Alt,Q
Open the File menu
Win+Alt,F
Open the Home tab and format text and numbers or use other tools such as Sort & Filter
Win+Alt,H
Open the Insert tab and insert a function, table, chart, hyperlink, or threaded comment
Win+Alt,N
Open the Data tab and refresh connections or use data tools
Win+Alt,A
Open the Review tab and use the Accessibility Checker or work with threaded comments and notes
Win+Alt,R
Open the View tab to choose a view, freeze rows or columns in your worksheet, or show gridlines and headers
Win+Alt,W

Work in the ribbon tabs and menus

Select the active tab of the ribbon and activate the access keys
Win+Alt
Move the focus to commands on the ribbon
Enter,Tab
or
Enter,Shift+Tab
Activate a selected button or open the list for a selected command
Space
or
Enter
Open the menu for a selected button
Alt+Down
When a menu or submenu is open, move to the next command
Esc

Keyboard shortcuts for editing cells

Insert a row above the current row
Win+Alt,H,I,R
Insert a column to the left of the current column
Win+Alt,H,I,C
Cut selection
Ctrl+X
Copy selection
Ctrl+C
Paste selection
Ctrl+V
Undo an action
Ctrl+Z
Redo an action
Ctrl+Y
Start a new line in the same cell
Alt+Enter
Insert a hyperlink
Ctrl+K
Insert a table
Ctrl+L
Insert a function
Shift+F3
Increase font size
Ctrl+Shift+.
Decrease font size
Ctrl+Shift+,
Apply a filter
Win+Alt,A,T
Re-apply a filter
Ctrl+Alt+L
Toggle AutoFilter on and off
Ctrl+Shift+L

Keyboard shortcuts for entering data

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

Keyboard shortcuts for editing data within a cell

Edit the selected cell
F2
Cycle through all the various combinations of absolute and relative references when a cell reference or range is selected in a formula
F4
Clear the selected cell
Del
Clear the selected cell and start editing
Bksp
Go to beginning of cell line
Home
Go to end of cell line
End
Select right by one character
Shift+Right
Select to the beginning of cell data
Shift+Home
Select to the end of cell data
Shift+End
Select left by one character
Shift+Left
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
or
Ctrl+Shift+Left
Insert the current date
Ctrl+;
Insert the current time
Ctrl+Shift+;
Copy a formula from the cell above
Ctrl+'
Copy the value from the cell above
Ctrl+Shift+'
Insert a formula argument
Ctrl+Shift+A

Keyboard shortcuts for formatting cells

Apply bold formatting
Ctrl+B
Apply italic formatting
Ctrl+I
Apply underline formatting
Ctrl+U
Paste formatting
Ctrl+Shift+V
Apply the outline border to the selected cells
Ctrl+Shift+7
Apply the number format
Ctrl+Shift+1
Apply the time format
Ctrl+Shift+2
Apply the date format
Ctrl+Shift+3
Apply the currency format
Ctrl+Shift+4
Apply the percentage format
Ctrl+Shift+5
Apply the scientific format
Ctrl+Shift+6
Apply outside border
Ctrl+Shift+7
Open the Number Format dialog box
Ctrl+1

Keyboard shortcuts for moving and scrolling within worksheets

Move up one cell
Up
or
Shift+Enter
Move down one cell
Down
or
Enter
Move right one cell
Right
or
Tab
Go to the beginning of the row
Home
Go to cell A1
Ctrl+Home
Go to the last cell of the used range
Ctrl+End
Move up/down one screen (28 rows)
Pg UpPg Dn
Move to the edge of the current data region
Ctrl+LeftRight
Move between ribbon and workbook content
Ctrl+F6
Move to a different ribbon tab
Tab
Insert a new sheet
Shift+F11
Switch to the next sheet
Ctrl+Alt+Pg Dn
Switch to the next sheet (when in Microsoft Teams or a browser other than Chrome)
Ctrl+Pg Dn
Switch to the previous sheet
Ctrl+Alt+Pg Up
Switch to previous sheet (when in Microsoft Teams or a browser other than Chrome)
Ctrl+Pg Up

Keyboard shortcuts for working with objects

Close/Open menu or drill up/down
Alt+UpDown
Follow hyperlink
Ctrl+Enter
Open a note for editing
Shift+F2
Open and reply to a threaded comment
Ctrl+Shift+F2
Rotate an object left/right
Alt+LeftRight

Keyboard shortcuts for working with cells, rows, columns, and objects

Select a range of cells
Shift+UpDownLeftRight
Select an entire column
Ctrl+Space
Select an 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
or
Ctrl+Shift+Left
Add a non-adjacent cell or range to a selection
Shift+F8
Insert cells, rows, or columns
Ctrl+=
Delete cells, rows, or columns
Ctrl+-
Hide rows
Ctrl+9
Unhide rows
Ctrl+Shift+9
Hide columns
Ctrl+0
Unhide columns
Ctrl+Shift+0

Keyboard shortcuts for moving within a selected range

Move from top to bottom (or forward through the selection)
Enter
Move from bottom to top (or back through the selection)
Shift+Enter
Move forward through a row (or down through a single-column selection)
Tab
Move back through a row (or up through a single-column selection)
Shift+Tab
Move to an active cell
Shift+Bksp
Move to an active cell and keep the selection
Ctrl+Bksp
Rotate the active cell through the corners of the selection
Ctrl+.
Move to the next selected range
Ctrl+Alt+Right
Move to the previous selected range
Ctrl+Alt+Left
Extend selection to the last used cell in the sheet
Ctrl+Shift+End
Extend selection to the first cell in the sheet
Ctrl+Shift+Home

Keyboard shortcuts for calculating data

Calculate workbook (refresh)
F9
Perform full calculation
Ctrl+Alt+Shift+F9
Refresh external data
Alt+F5
Refresh all external data
Ctrl+Alt+F5
Apply Auto Sum
Alt+=
Apply Flash Fill
Ctrl+E

Accessibility Shortcuts Menu (Alt+Shift+A)

Cycle between landmark regions
Ctrl+F6
or
Ctrl+Shift+F6
Move within a landmark region
Tab
or
Shift+Tab
Go to the Search or Tell Me field to run any command
Alt+Q
Display or hide Key Tips or access the ribbon
Win+Alt
Edit the selected cell
F2
Go to a specific cell
Ctrl+G
Move to another worksheet in the workbook
Ctrl+Alt+Pg UpPg Dn
Open the context menu
Shift+F10
or
Context Menu
Read row header
Ctrl+Alt+Shift+T
Read row until an active cell
Ctrl+Alt+Shift+Home
Read row from an active cell
Ctrl+Alt+Shift+End
Read column header
Ctrl+Alt+Shift+H
Read column until an active cell
Ctrl+Alt+Shift+Pg Up
Read column from an active cell
Ctrl+Alt+Shift+Pg Dn
Open a list of moving options within a dialog box
Ctrl+Alt+Space

Need more than shortcuts?
Visit the Microsoft Excel app page for an overview and helpful links.

Want to suggest a new app, report a bug, or get help? Email us at info@hkeys.appCopy email.

For anything else or just a quick hello, write to us at info@hkeys.appCopy email.