Get a printable PDF version
Easily improve your Excel speed by printing the PDF version of these keyboard shortcuts.
Search:
Select active cell only
Windows
+
Mac
+
Move screen to the active cell
Windows
+
Mac
+
Move active cell to the corner in the selection
Windows
+
Mac
+
Move active cell down in selection
Windows
Mac
Move active cell up in selection
Windows
+
Mac
+
Move active cell right in a selection
Windows
Mac
Move active cell left in a selection
Windows
+
Mac
+
Add borders
Windows
+
+
Mac
+
+
Add or remove right border
Windows
+
Mac
+
+
Add or remove left border
Windows
+
Mac
+
+
Add or remove top border
Windows
+
Mac
+
+
Add or remove bottom border
Windows
+
Mac
+
+
Remove borders
Windows
+
+
Mac
+
+
Edit the active cell
Windows
Mac
+
Insert or edit comment
Windows
+
Mac
+
+
Cancel editing cell
Windows
Mac
Select one character right of the cursor
Windows
+
Mac
+
Select one character left of the cursor
Windows
+
Mac
+
Move the cursor one word right
Windows
+
Mac
+
Move the cursor one word left
Windows
+
Mac
+
Select one word right of the cursor
Windows
+
+
Mac
+
+
Select one word left of the cursor
Windows
+
+
Mac
+
+
Select everything from the cursor up to the beginning of the cell
Windows
+
Mac
+
+
Select everything from the cursor up to the end of the cell
Windows
+
Mac
+
+
Delete word to the right of the cursor
Windows
+
Mac
+
Delete character to the left of cursor
Windows
Mac
Delete character to the right of cursor
Windows
Mac
+
Add a new line inside of a cell
Windows
+
Mac
+
+
Confirm entry and move down
Windows
Mac
Confirm entry and move up
Windows
+
Mac
+
Confirm entry and move right
Windows
Mac
Confirm entry and move left
Windows
+
Mac
+
Confirm entry and stay in the same cell
Windows
+
Mac
+
Enter the same data in multiple cells
Windows
+
Mac
+
Insert the current date
Windows
+
Mac
+
Insert the current time
Windows
+
+
Mac
+
Fill down from cell above the active cell
Windows
+
Mac
+
Fill right from cell to the left of the active cell
Windows
+
Mac
+
Copy the formula from the cell above the active cell
Windows
+
Mac
+
Copy the value from the cell above the active cell
Windows
+
+
Mac
+
+
Add a hyperlink
Windows
+
Mac
+
Display the AutoComplete list
Windows
+
Mac
+
Flash fill
Windows
+
Mac
Drag selection and move
Windows
Mac
Drag selection and copy
Windows
+
Mac
+
Drag selection and insert
Windows
+
Mac
+
Drag selection and insert a copy
Windows
+
+
Mac
+
+
Drag worksheet tab
Windows
+
Mac
+
Drag worksheet tab and copy
Windows
+
Mac
+
Extend the selection by one cell right
Windows
+
Mac
+
Extend the selection by one cell left
Windows
+
Mac
+
Extend the selection by one cell up
Windows
+
Mac
+
Extend the selection by one cell down
Windows
+
Mac
+
Extend the selection to the last cell to the right
Windows
+
+
Mac
+
+
Extend the selection to the last cell to the left
Windows
+
+
Mac
+
+
Extend the selection to the last cell upwards
Windows
+
+
Mac
+
+
Extend the selection to the last cell downwards
Windows
+
+
Mac
+
+
Extend the selection up one screen
Windows
+
Mac
+
+
Extend the selection down one screen
Windows
+
Mac
+
+
Extend the selection right one screen
Windows
+
+
Mac
+
+
+
Extend the selection left one screen
Windows
+
+
Mac
+
+
+
Extend the selection to the start of the row
Windows
+
Mac
+
+
Extend the selection to the first cell in the worksheet
Windows
+
+
Mac
+
+
+
Extend the selection to the last cell in the worksheet
Windows
+
+
Mac
+
+
+
Enable or disable the Extend selection mode
Windows
Mac
+
Create a new workbook
Windows
+
Mac
+
Open a workbook
Windows
+
Mac
+
Save the workbook
Windows
+
Mac
+
Open save as window
Windows
Mac
+
+
Print file
Windows
+
Mac
+
Open the print preview window
Windows
+
Mac
Close the current workbook
Windows
+
Mac
+
Close Excel application
Windows
+
Mac
+
Open the Formatting window
Windows
+
Mac
+
Open Formatting window on the Font tab
Windows
+
+
Mac
+
+
Apply or remove bold formatting
Windows
+
Mac
+
Apply or remove italic formatting
Windows
+
Mac
+
Apply or remove underscore formatting
Windows
+
Mac
+
Apply or remove strikethrough formatting
Windows
+
Mac
+
+
Add or remove a shadow font style
Windows
Mac
+
+
Add or remove an outline font style
Windows
Mac
+
+
Align center
Windows
+
+
+
Mac
+
Align left
Windows
+
+
+
Mac
+
Align right
Windows
+
+
+
Mac
+
Indent
Windows
+
+
Mac
+
+
Remove indent
Windows
+
+
Mac
+
+
+
Increase the font size by one step
Windows
+
+
+
Mac
+
+
Decrease the font size by one step
Windows
+
+
+
Mac
+
+
Switch between absolute, relative and mixed references
Windows
Mac
+
Open the Insert Function window
Windows
+
Mac
+
+
Autosum the selected cells
Windows
+
Mac
+
+
Enable or disable formulas
Windows
+
Mac
+
Insert function arguments
Windows
+
+
Mac
+
+
Enter an Array formula
Windows
+
+
Mac
+
+
(Re)calculate all worksheets
Windows
Mac
+
(Re)calculate the active worksheet
Windows
+
Mac
+
+
Force (re)calculate all worksheets
Windows
+
+
Mac
Evaluate a subset of a formula
Windows
Mac
+
Expand or collapse the formula bar
Windows
+
+
Mac
+
+
Display Function Arguments window
Windows
+
Mac
+
Confirm autocomplete function
Windows
Mac
Open options
Windows
+
+
Mac
+
Open the help window
Windows
Mac
+
Undo the last action
Windows
+
Mac
+
Redo the last action
Windows
+
Mac
+
Copy the contents of the selected cells
Windows
+
Mac
+
Repeat the last action
Windows
Mac
+
Cut the contents of the selected cells
Windows
+
Mac
+
Paste the content of the clipboard
Windows
+
Mac
+
Show the Paste Special window
Windows
+
+
Mac
+
+
Show the find window
Windows
+
Mac
+
Show the find and replace window
Windows
+
Mac
+
Find the next match
Windows
+
Mac
+
Find the previous match
Windows
+
+
Mac
+
+
Create an embedded chart
Windows
+
Mac
+
+
Create a chart one a new worksheet
Windows
Mac
+
Show Insert window
Windows
+
+
Mac
+
+
Insert row(s)
Windows
+
+
Mac
+
+
Insert column(s)
Windows
+
+
Mac
+
+
Show Delete (rows, columns or cells) window
Windows
+
Mac
+
Delete the contents of the selected cell(s)
Windows
Mac
+
Hide selected column(s)
Windows
+
Mac
+
Hide selected row(s)
Windows
+
Mac
+
Unhide/show rows
Windows
+
+
Mac
+
+
Unhide/show columns
Windows
+
+
Mac
+
+
Group rows or columns
Windows
+
+
Mac
+
+
Ungroup rows or columns
Windows
+
+
Mac
+
+
Open Group window
Windows
+
+
Mac
+
+
Open Ungroup window
Windows
+
+
Mac
+
+
Hide or show outline/group view
Windows
+
Mac
+
Zoom in
Windows
+
+
Mac
+
+
Zoom out
Windows
+
+
Mac
+
+
Open Name Manager window
Windows
+
Mac
+
+
Create names from row/column headings
Windows
+
+
Mac
+
+
+
Paste name into formula
Windows
Mac
Apply General number format
Windows
+
+
Mac
+
+
Apply Currency number format
Windows
+
+
Mac
+
+
Apply Percentage number format
Windows
+
+
Mac
+
+
Apply Scientific number format
Windows
+
+
Mac
+
+
Apply Date number format
Windows
+
+
Mac
+
+
Apply Time number format
Windows
+
+
Mac
+
+
Apply Number number format
Windows
+
+
Mac
+
+
Select the entire Pivot table
Windows
+
Mac
+
Group Pivot table items
Windows
+
+
Mac
+
+
Ungroup Pivot table items
Windows
+
+
Mac
+
+
Hide Pivot table item(s)
Windows
+
Mac
Create a Pivot chart on the current worksheet
Windows
+
Mac
Create a Pivot chart on a new worksheet
Windows
Mac
+
Open the Pivot table/Pivot chart wizard
Windows
+
+
Mac
+
+
Move to the next button/field
Windows
Mac
Move to the previous button/field
Windows
+
Mac
+
Move to the next tab
Windows
+
Mac
+
Move to the previous tab
Windows
+
+
Mac
+
+
Accept
Windows
Mac
Check or uncheck a checkbox
Windows
Mac
Cancel and close the window
Windows
Mac
Open Spelling window
Windows
Mac
+
Open Thesaurus window
Windows
+
Mac
+
+
Open Macro window
Windows
+
Mac
+
+
Open VBA Editor window
Windows
+
Mac
+
+
Show cell Style window
Windows
+
Mac
+
+
Show right-click menu
Windows
+
Mac
+
+
Select the entire row
Windows
+
Mac
+
Select the entire column
Windows
+
Mac
+
Select the entire worksheet or table
Windows
+
Mac
+
Add adjacent cells to the current selection
Windows
+
Mac
+
Add non-adjacent cells to the current selection
Windows
+
Mac
+
Get the same selection in the next column
Windows
Mac
+
Get the same selection in the previous column
Windows
Mac
+
+
Move to the next selection in multiple selections
Windows
+
+
Mac
+
+
Move to the previous selection in multiple selections
Windows
+
+
Mac
+
+
Toggle Add to selection mode
Windows
+
Mac
+
+
Cancel selection
Windows
Mac
Display Go To window
Windows
+
Mac
+
Select the region around the active cell
Windows
+
+
Mac
+
+
Select the complete worksheet or table
Windows
+
Mac
+
Select the current array
Windows
+
Mac
+
Select row differences
Windows
+
Mac
+
Select column differences
Windows
+
+
Mac
+
+
Select direct formula precedents
Windows
+
Mac
+
Select all formula precedents
Windows
+
+
Mac
+
+
Select direct formula dependents
Windows
+
Mac
+
Select all formula dependents
Windows
+
+
Mac
+
+
Remove hidden cells from selection
Windows
+
Mac
+
+
Insert a table
Windows
+
Mac
+
Enable or disable Autofilter
Windows
+
+
Mac
+
+
Activate filter
Windows
+
Mac
+
Select entire table row
Windows
+
Mac
+
Select entire table column
Windows
+
Mac
+
Select entire table
Windows
+
Mac
+
Clear slicer filter
Windows
+
Mac
+
Enable or disable table total row
Windows
+
+
Mac
+
+
Expand or collapse ribbon
Windows
+
Mac
+
+
Show access keys (Ribbon shortcuts)
Windows
Mac
Move to the next ribbon button/field
Windows
Mac
Activate the selected button/field
Windows
Mac
Confirm button/field change
Windows
Mac
Open help window for the selected button/field
Windows
Mac
Switch to the File tab
Windows
+
Mac
Switch to the Home tab
Windows
+
Mac
Switch to the Insert tab
Windows
+
Mac
Switch to the Page Layout tab
Windows
+
Mac
Switch to the Formula tab
Windows
+
Mac
Switch to the Data tab
Windows
+
Mac
Switch to the Review tab
Windows
+