Microsoft Excel Keyboard Shortcuts
All 333 Microsoft Excel keyboard shortcuts in one place, so you can analyze data in spreadsheets faster
Microsoft Excel is an office & documents application developed by Microsoft. It lets users analyze data in spreadsheets with a professional-grade toolset.
For Microsoft Excel users, mastering keyboard shortcuts is one of the fastest ways to boost productivity. Quick access to tools and commands keeps the creative flow unbroken.
Available on macOS and Windows, Microsoft Excel serves a broad audience of professionals who benefit from learning platform-specific shortcut keys.
macOS
Windows
333 shortcuts
21 categories
Show shortcuts for:
Jump to Section (21 sections)
Frequently used shortcuts 36 shortcuts
Close a workbook
N/A Ctrl +W
Open a workbook
N/A Ctrl +O
Go to the Home tab
N/A Alt +H
Save a workbook
N/A Ctrl +S
Copy selection
N/A Ctrl +C
Paste selection
N/A Ctrl +V
Undo recent action
N/A Ctrl +Z
Remove cell contents
N/A Delete
Choose a fill color
N/A Alt +H +H
Cut selection
N/A Ctrl +X
Go to the Insert tab
N/A Alt +N
Apply bold formatting
N/A Ctrl +B
Center align cell contents
N/A Alt +H +A +C
Go to the Page Layout tab
N/A Alt +P
Go to the Data tab
N/A Alt +A
Go to the View tab
N/A Alt +W
Open the context menu
N/A Shift +F10
Add borders
N/A Alt +H +B
Delete column
N/A Alt +H +D +C
Go to the Formula tab
N/A Alt +M
Hide the selected rows
N/A Ctrl +9
Hide the selected columns
N/A Ctrl +0
Go to a specific cell
N/A Ctrl +G
Move down
N/A PageDown
Move down
N/A Down
Move up
N/A PageUp
Move up
N/A Up
Print a workbook
N/A Ctrl +P
Open the Save As dialog box
N/A Alt +F2
Use Find
N/A Ctrl +F
Use Find
N/A Shift +F3
Jump to Search or Tell me
N/A Alt +Q
Repeat Find downward
N/A Shift +F4
Repeat Find upward
N/A Ctrl +Shift +F4
Insert a chart
N/A Alt +F1
Display the access keys (ribbon commands) on the classic ribbon when using Narrator
N/A Alt +.
Access keys for ribbon tabs 9 shortcuts
Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content
N/A Alt +Q
Open the File menu
N/A Alt +F
Open the Home tab and format text and numbers and use the Find tool
N/A Alt +H
Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes
N/A Alt +N
Open the Page Layout tab and work with themes, page setup, scale, and alignment
N/A Alt +P
Open the Formulas tab and insert, trace, and customize functions and calculations
N/A Alt +M
Open the Data tab and connect to, sort, filter, analyze, and work with data
N/A Alt +A
Open the Review tab and check spelling, add notes and threaded comments, and protect sheets and workbooks
N/A Alt +R
Open the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros
N/A Alt +W
Work in the ribbon with the keyboard 15 shortcuts
Select the active tab on the ribbon and activate the access keys
N/A Alt
Move the focus to commands on the ribbon or add-in pane
N/A Tab
Move the focus to commands on the ribbon or add-in pane backwards
N/A Shift +Tab
Move down among the items on the ribbon / Open the list for a selected command / When a menu or submenu is open, move to the next command
N/A Down
Move up among the items on the ribbon
N/A Up
Move left among the items on the ribbon / Move to the submenu when a main menu is open or selected
N/A Left
Move right among the items on the ribbon
N/A Right
Show the tooltip for the ribbon element currently in focus
N/A Ctrl +Shift +F10
Activate a selected button
N/A Space
Activate a selected button
N/A Enter
Open the menu for a selected button
N/A Alt +Down
Expand or collapse the ribbon
N/A Ctrl +F1
Open a context menu
N/A Shift +F10
Move from one group of controls to another left
N/A Ctrl +Left
Move from one group of controls to another right
N/A Ctrl +Right
Keyboard shortcuts for navigating in cells 26 shortcuts
Move to the previous cell in a worksheet or the previous option in a dialog box
N/A Shift +Tab
Move one cell up in a worksheet
N/A Up
Move one cell down in a worksheet
N/A Down
Move one cell left in a worksheet
N/A Left
Move one cell right in a worksheet
N/A Right
Move to the edge of the current data region in a worksheet
N/A Ctrl +Up
Move to the edge of the current data region in a worksheet
N/A Ctrl +Down
Move to the edge of the current data region in a worksheet
N/A Ctrl +Left
Move to the edge of the current data region in a worksheet
N/A Ctrl +Right
Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode
N/A End
Move to the last cell on a worksheet, to the lowest used row of the rightmost used column
N/A Ctrl +End
Extend the selection of cells to the last used cell on the worksheet (lower-right corner)
N/A Ctrl +Shift +End
Move to the cell in the upper-left corner of the window when Scroll lock is turned on
N/A Home
Move to the beginning of a worksheet
N/A Ctrl +Home
Move one screen down in a worksheet
N/A PageDown
Move to the next sheet in a workbook
N/A Ctrl +PageDown
Move one screen to the right in a worksheet
N/A Alt +PageDown
Move one screen up in a worksheet
N/A PageUp
Move one screen to the left in a worksheet
N/A Alt +PageUp
Move to the previous sheet in a workbook
N/A Ctrl +PageUp
Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells
N/A Tab
Open the list of validation choices on a cell that has data validation option applied to it
N/A Alt +Down
Cycle through floating shapes, such as text boxes or images
N/A Ctrl +Alt +5
Exit the floating shape navigation and return to the normal navigation
N/A Esc
Zoom in
N/A Ctrl +Alt +=
Zoom out
N/A Ctrl +Alt +-
Keyboard shortcuts for formatting cells 49 shortcuts
Open the Format Cells dialog box / Open the Number Format dialog box
N/A Ctrl +1
Format fonts in the Format Cells dialog box
N/A Ctrl +Shift +F
Format fonts in the Format Cells dialog box
N/A Ctrl +Shift +P
Edit the active cell and put the insertion point at the end of its contents
N/A F2
Insert a note. Open and edit a cell note
N/A Shift +F2
Insert a threaded comment. Open and reply to a threaded comment
N/A Ctrl +Shift +F2
Open the Insert dialog box to insert blank cells / Apply the outline border to the selected cells
N/A Ctrl +Shift ++
Open the Delete dialog box to delete selected cells
N/A Ctrl +-
Enter the current time
N/A Ctrl +Shift +;
Enter the current date
N/A Ctrl +;
Switch between displaying cell values or formulas in the worksheet
N/A Ctrl +`
Copy a formula from the cell above the active cell into the cell or the formula bar
N/A Ctrl +'
Move the selected cells
N/A Ctrl +X
Copy the selected cells
N/A Ctrl +C
Paste content at the insertion point, replacing any selection
N/A Ctrl +V
Open the Paste Special dialog box
N/A Ctrl +Alt +V
Italicize text or remove italic formatting / Apply italic formatting
N/A Ctrl +I
Italicize text or remove italic formatting
N/A Ctrl +3
Bold text or remove bold formatting / Apply bold formatting
N/A Ctrl +B
Bold text or remove bold formatting
N/A Ctrl +2
Underline text or remove underline / Apply underline formatting
N/A Ctrl +U
Underline text or remove underline
N/A Ctrl +4
Apply or remove strikethrough formatting
N/A Ctrl +5
Switch between hiding objects, displaying objects, and displaying placeholders for objects
N/A Ctrl +6
Apply an outline border to the selected cells
N/A Ctrl +Shift +&
Remove the outline border from the selected cells
N/A Ctrl +Shift +_
Display or hide the outline symbols
N/A Ctrl +8
Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
N/A Ctrl +D
Apply the General number format
N/A Ctrl +Shift +`
Apply the Currency format with two decimal places (negative numbers in parentheses)
N/A Ctrl +Shift +$
Apply the Percentage format with no decimal places
N/A Ctrl +Shift +%
Apply the Scientific number format with two decimal places
N/A Ctrl +Shift +^
Apply the Date format with the day, month, and year
N/A Ctrl +Shift +#
Apply the Time format with the hour and minute, and AM or PM
N/A Ctrl +Shift +@
Apply the Number format with two decimal places, thousands separator, and minus sign for negative values
N/A Ctrl +Shift +!
Open the Insert hyperlink dialog box
N/A Ctrl +K
Check spelling in the active worksheet or selected range
N/A F7
Display the Quick Analysis options for selected cells that contain data
N/A Ctrl +Q
Display the Create Table dialog box
N/A Ctrl +L
Display the Create Table dialog box
N/A Ctrl +T
Open the Workbook Statistics dialog box
N/A Ctrl +Shift +G
Paste formatting
N/A Ctrl +Shift +V
Apply the number format
N/A Ctrl +Shift +1
Apply the time format
N/A Ctrl +Shift +2
Apply the date format
N/A Ctrl +Shift +3
Apply the currency format
N/A Ctrl +Shift +4
Apply the percentage format
N/A Ctrl +Shift +5
Apply the scientific format
N/A Ctrl +Shift +6
Apply outside border
N/A Ctrl +Shift +7
Keyboard shortcuts in the Paste Special dialog box 11 shortcuts
Paste all cell contents and formatting
N/A A
Paste only the formulas as entered in the formula bar
N/A F
Paste only the values (not the formulas)
N/A V
Paste only the copied formatting
N/A T
Paste only comments and notes attached to the cell
N/A C
Paste only the data validation settings from copied cells
N/A N
Paste all cell contents and formatting from copied cells
N/A H
Paste all cell contents without borders
N/A X
Paste only column widths from copied cells
N/A W
Paste only formulas and number formats from copied cells
N/A R
Paste only the values (not formulas) and number formats from copied cells
N/A U
Navigate the worksheet 7 shortcuts
Move one cell to the right
Tab Tab
Move one cell up, down, left, or right
Up Up
Move one cell up, down, left, or right
Down Down
Move one cell up, down, left, or right
Left Left
Move one cell up, down, left, or right
Right Right
Move to the next sheet in the workbook
Opt +Right N/A
Move to the previous sheet in the workbook
Opt +Left N/A
Format and edit data 6 shortcuts
Apply outline border
Opt +Cmd +0 N/A
Remove outline border
Opt +Cmd +- N/A
Hide column(s)
Cmd +0 N/A
Hide row(s)
N/A Ctrl +9
Unhide column(s)
Shift +Cmd +0 N/A
Unhide row(s)
Ctrl +Shift +9 N/A
Work in cells or the formula bar 28 shortcuts
Move to the cell on the right
Tab Tab
Move within cell text
Up Up
Move within cell text
Down Down
Move within cell text
Left Left
Move within cell text
Right Right
Copy a selection
Cmd +C Ctrl +C
Paste a selection
Cmd +V Ctrl +V
Cut a selection
Cmd +X Ctrl +X
Undo an action
Cmd +Z Ctrl +Z
Redo an action
Cmd +Y Ctrl +Y
Redo an action
Shift +Cmd +Z N/A
Apply bold formatting to the selected text
Cmd +B Ctrl +B
Apply italic formatting to the selected text
Cmd +I Ctrl +I
Underline the selected text
Cmd +U Ctrl +U
Select all
Cmd +A Ctrl +A
Select a range of cells
Shift +Left Shift +Left
Select a range of cells
Shift +Right Shift +Right
Insert a line break within a cell
Opt +Cmd +Enter N/A
Insert a line break within a cell
Ctrl +Opt +Enter N/A
Move the cursor to the beginning of the current line within a cell
Cmd +Left N/A
Move the cursor to the end of the current line within a cell
Cmd +Right N/A
Move the cursor to the beginning of the current cell
Cmd +Up N/A
Move the cursor to the end of the current cell
Cmd +Down N/A
Move the cursor up by one paragraph within a cell that contains a line break
Opt +Up N/A
Move the cursor down by one paragraph within a cell that contains a line break
Opt +Down N/A
Move the cursor right by one word
Opt +Right N/A
Move the cursor left by one word
Opt +Left N/A
Insert an AutoSum formula
Shift +Cmd +T N/A
Work with cells (Android) 17 shortcuts
Move one cell to the right
N/A Tab
Move one cell up, down, left, or right
N/A Up
Move one cell up, down, left, or right
N/A Down
Move one cell up, down, left, or right
N/A Left
Move one cell up, down, left, or right
N/A Right
Save a worksheet
N/A Ctrl +S
Copy a selection
N/A Ctrl +C
Paste a selection
N/A Ctrl +V
Cut a selection
N/A Ctrl +X
Undo an action
N/A Ctrl +Z
Redo an action
N/A Ctrl +Y
Apply bold formatting
N/A Ctrl +B
Apply italic formatting
N/A Ctrl +I
Apply underline formatting
N/A Ctrl +U
Select all
N/A Ctrl +A
Find
N/A Ctrl +F
Insert a line break within a cell
N/A Alt +Enter
Access keys: Shortcuts for using the ribbon (Web) 8 shortcuts
Get to the ribbon
N/A Alt +F6
Go to the Search or Tell Me field on the ribbon and type a search term
N/A Alt +Q
Open the File menu
N/A Alt +F
Open the Home tab and format text and numbers or use other tools such as Sort & Filter
N/A Alt +H
Open the Insert tab and insert a function, table, chart, hyperlink, or threaded comment
N/A Alt +N
Open the Data tab and refresh connections or use data tools
N/A Alt +A
Open the Review tab and use the Accessibility Checker or work with threaded comments and notes
N/A Alt +R
Open the View tab to choose a view, freeze rows or columns in your worksheet, or show gridlines and headers
N/A Alt +W
Work in the ribbon tabs and menus (Web) 7 shortcuts
Select the active tab of the ribbon and activate the access keys
N/A Alt
Move the focus to commands on the ribbon / Activate a selected button / Open the list for a selected command
N/A Enter
Move the focus to commands on the ribbon
N/A Tab
Move the focus to commands on the ribbon
N/A Shift +Tab
Activate a selected button / Open the list for a selected command
N/A Space
Open the menu for a selected button
N/A Alt +Down
When a menu or submenu is open, move to the next command
N/A Esc
Keyboard shortcuts for editing cells (Web) 16 shortcuts
Insert a row above the current row
N/A Alt +H +I +R
Insert a column to the left of the current column
N/A Alt +H +I +C
Cut selection
N/A Ctrl +X
Copy selection
N/A Ctrl +C
Paste selection
N/A Ctrl +V
Undo an action
N/A Ctrl +Z
Redo an action
N/A Ctrl +Y
Start a new line in the same cell
N/A Alt +Enter
Insert a hyperlink
N/A Ctrl +K
Insert a table
N/A Ctrl +L
Insert a function
N/A Shift +F3
Increase font size
N/A Ctrl +Shift +]
Decrease font size
N/A Ctrl +Shift +[
Apply a filter
N/A Alt +A +T
Re-apply a filter
N/A Ctrl +Alt +L
Toggle AutoFilter on and off
N/A Ctrl +Shift +L
Keyboard shortcuts for entering data (Web) 5 shortcuts
Complete cell entry and select the cell below
N/A Enter
Complete cell entry and select the cell above
N/A Shift +Enter
Complete cell entry and select the next cell in the row
N/A Tab
Complete cell entry and select the previous cell in the row
N/A Shift +Tab
Cancel cell entry
N/A Esc
Keyboard shortcuts for editing data within a cell (Web) 17 shortcuts
Edit the selected cell
N/A F2
Cycle through all the various combinations of absolute and relative references when a cell reference or range is selected in a formula
N/A F4
Clear the selected cell
N/A Delete
Clear the selected cell and start editing
N/A Backspace
Go to beginning of cell line
N/A Home
Go to end of cell line
N/A End
Select right by one character
N/A Shift +Right
Select to the beginning of cell data
N/A Shift +Home
Select to the end of cell data
N/A Shift +End
Select left by one character
N/A 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
N/A Ctrl +Shift +Right
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
N/A Ctrl +Shift +Left
Insert the current date
N/A Ctrl +;
Insert the current time
N/A Ctrl +Shift +;
Copy a formula from the cell above
N/A Ctrl +'
Copy the value from the cell above
N/A Ctrl +Shift +'
Insert a formula argument
N/A Ctrl +Shift +A
Keyboard shortcuts for moving and scrolling within worksheets (Web) 19 shortcuts
Move up one cell
N/A Up
Move up one cell
N/A Shift +Enter
Move down one cell
N/A Down
Move down one cell
N/A Enter
Move right one cell
N/A Right
Move right one cell / Move to a different ribbon tab
N/A Tab
Go to the beginning of the row
N/A Home
Go to cell A1
N/A Ctrl +Home
Go to the last cell of the used range
N/A Ctrl +End
Move down one screen (28 rows)
N/A PageDown
Move up one screen (28 rows)
N/A PageUp
Move to the edge of the current data region
N/A Ctrl +Right
Move to the edge of the current data region
N/A Ctrl +Left
Move between ribbon and workbook content
N/A Ctrl +F6
Insert a new sheet
N/A Shift +F11
Switch to the next sheet
N/A Ctrl +Alt +PageDown
Switch to the next sheet (when in Microsoft Teams or a browser other than Chrome)
N/A Ctrl +PageDown
Switch to the previous sheet
N/A Ctrl +Alt +PageUp
Switch to previous sheet (when in Microsoft Teams or a browser other than Chrome)
N/A Ctrl +PageUp
Keyboard shortcuts for working with objects (Web) 7 shortcuts
Open menu or drill down
N/A Alt +Down
Close menu or drill up
N/A Alt +Up
Follow hyperlink
N/A Ctrl +Enter
Open a note for editing
N/A Shift +F2
Open and reply to a threaded comment
N/A Ctrl +Shift +F2
Rotate an object left
N/A Alt +Left
Rotate an object right
N/A Alt +Right
Keyboard shortcuts for working with cells, rows, columns, and objects (Web) 15 shortcuts
Select a range of cells
N/A Shift +Up
Select a range of cells
N/A Shift +Down
Select a range of cells
N/A Shift +Left
Select a range of cells
N/A Shift +Right
Select an entire column
N/A Ctrl +Space
Select an entire row
N/A 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
N/A Ctrl +Shift +Right
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
N/A Ctrl +Shift +Left
Add a non-adjacent cell or range to a selection
N/A Shift +F8
Insert cells, rows, or columns
N/A Ctrl ++
Delete cells, rows, or columns
N/A Ctrl +-
Hide rows
N/A Ctrl +9
Unhide rows
N/A Ctrl +Shift +9
Hide columns
N/A Ctrl +0
Unhide columns
N/A Ctrl +Shift +0
Moving within a selected range 11 shortcuts
Move from top to bottom (or forward through the selection)
Enter Enter
Move from bottom to top (or back through the selection)
Shift +Enter Shift +Enter
Move forward through a row (or down through a single-column selection)
Tab Tab
Move back through a row (or up through a single-column selection)
Shift +Tab Shift +Tab
Move to an active cell
Shift +Backspace Shift +Backspace
Move to an active cell and keep the selection
Ctrl +Backspace Ctrl +Backspace
Rotate the active cell through the corners of the selection
Ctrl +. Ctrl +.
Move to the next selected range
Ctrl +Opt +Right Ctrl +Alt +Right
Move to the previous selected range
Ctrl +Opt +Left Ctrl +Alt +Left
Extend selection to the last used cell in the sheet
Ctrl +Shift +End Ctrl +Shift +End
Extend selection to the first cell in the sheet
Ctrl +Shift +Home Ctrl +Shift +Home
Calculating data 6 shortcuts
Calculate workbook (refresh)
F9 F9
Perform full calculation
Ctrl +Opt +Shift +F9 Ctrl +Alt +Shift +F9
Refresh external data
Opt +F5 Alt +F5
Refresh all external data
Ctrl +Opt +F5 Ctrl +Alt +F5
Apply Auto Sum
Opt += Alt +=
Apply Flash Fill
Ctrl +E Ctrl +E
Accessibility Shortcuts 18 shortcuts
Cycle between landmark regions
Ctrl +F6 Ctrl +F6
Cycle between landmark regions (reverse)
Ctrl +Shift +F6 Ctrl +Shift +F6
Move within a landmark region
Tab Tab
Move within a landmark region (reverse)
Shift +Tab Shift +Tab
Go to the Search or Tell Me field to run any command
Opt +Q Alt +Q
Display or hide Key Tips or access the ribbon
N/A Alt +Right
Edit the selected cell
F2 F2
Go to a specific cell
Ctrl +G Ctrl +G
Move to another worksheet in the workbook (next)
Ctrl +Opt +PageDown Ctrl +Alt +PageDown
Move to another worksheet in the workbook (previous)
Ctrl +Opt +PageUp Ctrl +Alt +PageUp
Open the context menu
Shift +F10 Shift +F10
Read row header
Ctrl +Opt +Shift +T Ctrl +Alt +Shift +T
Read row until an active cell
Ctrl +Opt +Shift +Home Ctrl +Alt +Shift +Home
Read row from an active cell
Ctrl +Opt +Shift +End Ctrl +Alt +Shift +End
Read column header
Ctrl +Opt +Shift +H Ctrl +Alt +Shift +H
Read column until an active cell
Ctrl +Opt +Shift +PageUp Ctrl +Alt +Shift +PageUp
Read column from an active cell
Ctrl +Opt +Shift +PageDown Ctrl +Alt +Shift +PageDown
Open a list of moving options within a dialog box
Ctrl +Opt +Space Ctrl +Alt +Space
We've Built 10s Of 1000s Of Keyboard Shortcuts Into The BuildBox Macropad
The BuildBox Macropad is the ultimate shortcut machine. One device with up to 160 configurable shortcuts for apps like Microsoft Excel available at your fingertips, a crystal clear display showing what every key does, and a hall-effect scroll wheel for scrubbing through video, audio and graphic editing applications like butter!
Drop your email below to be eligible for our first production run of 500 BuildBox units, at a HUGE discount price:
Keyboard Shortcuts for Similar Applications
- Adobe Acrobat Keyboard Shortcuts
- Google Docs Keyboard Shortcuts
- Google Drive Keyboard Shortcuts
- Google Sheets Keyboard Shortcuts
- Google Slides Keyboard Shortcuts
- Keynote Keyboard Shortcuts
- LibreOffice Calc Keyboard Shortcuts
- LibreOffice Impress Keyboard Shortcuts
- LibreOffice Writer Keyboard Shortcuts
- Microsoft PowerPoint Keyboard Shortcuts
- Microsoft Word Keyboard Shortcuts
- Numbers Keyboard Shortcuts
- Pages Keyboard Shortcuts