Free Shortcut Cheat Sheets
https://hkeys.app
Home / Apps / Microsoft Excel

Microsoft Excel

Microsoft Excel is a spreadsheet application by Microsoft for data analysis, calculation, and reporting.

Frequently used shortcuts

Paste selection
+
V
or
+
V
Copy selection
+
C
or
+
C
Clear selection
Save workbook
+
S
or
+
S
Undo action
+
Z
or
+
Z
Redo action
+
Y
or
+
Y
or
+
+
Z
Cut selection
+
X
or
+
X
or
+
Apply bold formatting
+
B
or
+
B
Print workbook
+
P
or
+
P
Open Visual Basic
+
F11
Fill cells down
+
D
or
+
D
Fill cells right
+
R
or
+
R
Insert cells
+
+
=
Delete cells
+
-
or
+
-
Calculate all open workbooks
F9
or
+
=
Close window
+
W
or
+
W
Quit Excel
+
Q
Display the Go To dialog box
+
G
or
F5
Display the Format Cells dialog box
+
1
or
+
1
Display the Replace dialog box
+
H
or
+
+
H
Use Paste Special
+
+
V
or
+
+
V
or
+
+
V
Apply underline formatting
+
U
Apply italic formatting
+
I
or
+
I
Open a new blank workbook
+
N
or
+
N
Create a new workbook from template
+
+
P
Display the Save As dialog box
+
+
S
or
F12
Display the Help window
F1
or
+
/
Select all
+
A
or
+
+
Add or remove a filter
+
+
F
or
+
+
L
Minimize or maximize the ribbon tabs
+
+
R
Display the Open dialog box
+
O
or
+
O
Check spelling
F7
Open the thesaurus
+
F7
Display the Formula Builder
+
F3
Open the Define Name dialog box
+
F3
Insert or reply to a threaded comment
+
Open the Create names dialog box
+
+
F3
Insert a new sheet. *
+
F11
Print preview
+
P
or
+
P

Work in windows and dialog boxes

Expand or minimize the ribbon
+
+
R
Switch to full screen view
+
+
F
Switch to the next application
+
Switch to the previous application
+
+
Close the active workbook window
+
W
Take a screenshot and save it on your desktop
+
+
3
Minimize the active window
+
F9
Maximize or restore the active window
+
F10
or
+
F10
Hide Excel
+
H
Move to the next box, option, control, or command
Move to the previous box, option, control, or command
+
Exit a dialog box or cancel an action
Esc
Perform the action assigned to the default button (the button with the bold outline)
Cancel the command and close the dialog box or menu
Esc

Move and scroll in a sheet or workbook

Move one cell up, down, left, or right
or
or
or
Move to the edge of the current data region
+
or
+
or
+
or
+
Move to the beginning of the row
Home
or
Fn +
Move to the beginning of the sheet
+
Home
or
+
Fn +
Move to the last cell in use on the sheet
+
End
or
+
Fn +
Move down one screen
Pg Dn
or
Fn +
Move up one screen
Pg Up
or
Fn +
Move one screen to the right
+
Pg Dn
or
+
Fn +
Move one screen to the left
+
Pg Up
or
+
Fn +
Move to the next sheet in the workbook
+
Pg Dn
or
+
Move to the previous sheet in the workbook
+
Pg Dn
or
+
Scroll to display the active cell
+
Display the Go To dialog box
+
G
Display the Find dialog box
+
F
or
+
F5
Access search (when in a cell or when a cell is selected)
+
F
Move between unlocked cells on a protected sheet
Scroll horizontally
+
Scroll Up
or
+
Scroll Down

Enter data on a sheet

Edit the selected cell
F2
Complete a cell entry and move forward in the selection
Start a new line in the same cell
+
or
+
+
Fill the selected cell range with the text that you type
+
or
+
Complete a cell entry and move up in the selection
+
Complete a cell entry and move to the right in the selection
Complete a cell entry and move to the left in the selection
+
Cancel a cell entry
Esc
Delete the character to the left of the insertion point or delete the selection
Delete the character to the right of the insertion point or delete the selection. Note: Some smaller keyboards do not have this key
or
Fn +
Delete text to the end of the line. Note: Some smaller keyboards do not have this key
+
or
+
Fn +
Move one character up, down, left, or right
or
or
or
Move to the beginning of the line
Home
or
Fn +
Insert a note
+
F2
Open and edit a cell note
+
F2
Insert a threaded comment
+
+
F2
Open and reply to a threaded comment
+
+
F2
Fill down
+
D
or
+
D
Fill to the right
+
R
or
+
R
Define a name
+
L

Work in cells or the Formula bar

Turn on or off tooltips for checking formulas directly in the formula bar
+
+
P
Edit the selected cell
F2
Expand or collapse the formula bar
+
+
U
Edit the active cell and then clear it or delete the preceding character in the active cell as you edit the cell contents
Complete a cell entry
Enter a formula as an array formula
+
+
or
+
+
Cancel an entry in the cell or formula bar
Esc
Display the Formula Builder after you type a valid function name in a formula
+
A
Insert a hyperlink
+
K
or
+
K
Edit the active cell and position the insertion point at the end of the line
+
U
Open the Formula Builder
+
F3
Calculate the active sheet
+
F9
Display the context menu
+
F10
Start a formula
=
Toggle the formula reference style between absolute, relative, and mixed
+
T
or
F4
Insert the AutoSum formula
+
+
T
Enter the date
+
;
Enter the time
+
;
Copy the value from the cell above the active cell into the cell or the formula bar
+
+
'
Alternate between displaying cell values and displaying cell formulas
+
`
Copy a formula from the cell above the active cell into the cell or the formula bar
+
'
Display the AutoComplete list
+
Define a name
+
L
Open the Smart Lookup pane
+
+
+
L
Calculate all worksheets in all open workbooks
+
+
F9
Check dependent formulas, and then calculate all cells in all open workbooks
+
+
+
F9

Format and edit data

Edit the selected cell
F2
Create a table
+
T
or
+
T
Insert a line break in a cell
+
+
or
+
+
Insert special characters like symbols, including emoji
+
+
Increase font size
+
+
.
Decrease font size.
+
+
,
Align center
+
E
Align left
+
L
Display the Modify Cell Style dialog box
+
+
L
Display the Format Cells dialog box
+
1
Apply the general number format
+
+
`
Apply the currency format with two decimal places (negative numbers appear in red with parentheses)
+
+
4
Apply the percentage format with no decimal places
+
+
5
Apply the exponential number format with two decimal places
+
+
6
Apply the date format with the day, month, and year
+
+
3
Apply the time format with the hour and minute, and indicate AM or PM
+
+
2
Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values
+
+
1
Apply the outline border around the selected cells
+
+
0
Add an outline border to the right of the selection
+
+
Add an outline border to the left of the selection
+
+
Add an outline border to the top of the selection
+
+
Add an outline border to the bottom of the selection
+
+
Remove outline borders
+
+
-
Apply or remove bold formatting
+
B
Apply or remove italic formatting
+
I
Apply or remove underline formatting
+
U
Apply or remove strikethrough formatting
+
+
X
Hide a column
+
+
0
or
+
+
0
Unhide a column
+
+
0
or
+
+
0
Hide a row
+
+
9
or
+
+
9
Unhide a row
+
+
9
or
+
+
9
Edit the active cell
+
U
Cancel an entry in the cell or the formula bar
Esc
Edit the active cell and then clear it or delete the preceding character in the active cell as you edit the cell contents
Paste text into the active cell
+
V
Complete a cell entry
Give selected cells the current cell's entry
+
or
+
Enter a formula as an array formula
+
+
or
+
+
Display the Formula Builder after you type a valid function name in a formula
+
A

Select cells, columns, or rows

Extend the selection by one cell
+
or
+
or
+
or
+
Extend the selection to the last nonblank cell in the same column or row as the active cell
+
+
or
+
+
or
+
+
or
+
+
Extend the selection to the beginning of the row
+
Home
or
+
Fn +
Extend the selection to the beginning of the sheet
+
+
Home
or
+
+
Fn +
Extend the selection to the last cell used on the sheet (lower-right corner)
+
+
End
or
+
+
Fn +
Select the entire column. *
+
Select the entire row
+
Select the current region or entire sheet. Press more than once to expand the selection
+
A
Select only visible cells
+
+
8
Select only the active cell when multiple cells are selected
+
Extend the selection down one screen
+
Pg Dn
or
+
Fn +
Extend the selection up one screen
+
Pg Up
or
+
Fn +
Alternate between hiding objects, displaying objects, and displaying placeholders for objects
+
6
Turn on the capability to extend a selection by using the arrow keys
F8
Add another range of cells to the selection
+
F8
Select the current array, which is the array that the active cell belongs to
+
/
Select cells in a row that don't match the value in the active cell in that row
+
\
Select only cells that are directly referred to by formulas in the selection
+
[
Select all cells that are directly or indirectly referred to by formulas in the selection
+
+
[
Select only cells with formulas that refer directly to the active cell
+
]
Select all cells with formulas that refer directly or indirectly to the active cell
+
+
]

Work with a selection

Copy a selection
+
C
or
+
C
Paste a selection
+
V
or
+
V
Cut a selection
+
X
or
+
X
Clear a selection
Delete the selection
+
-
Undo the last action
+
Z
Hide a column
+
+
0
or
+
+
0
Unhide a column
+
+
0
or
+
+
0
Hide a row
+
+
9
or
+
+
9
Unhide a row
+
+
9
or
+
+
9
Move selected rows, columns, or cells
+
MouseDrag
Move from top to bottom within the selection (down). *
Move from bottom to top within the selection (up). *
+
Move from left to right within the selection, or move down one cell if only one column is selected
Move from right to left within the selection, or move up one cell if only one column is selected
+
Move clockwise to the next corner of the selection
+
.
Group selected cells
+
+
K
Ungroup selected cells
+
+
J

Use charts

Insert a new chart sheet. *
F11
Cycle through chart object selection
or
or
or

Sort, filter, and use PivotTable reports

Open the Sort dialog box
+
+
R
Add or remove a filter
+
+
F
or
+
+
L
Display the Filter list or PivotTable page field pop-up menu for the selected cell
+

Outline data

Display or hide outline symbols
+
8
Hide selected rows
+
9
Unhide selected rows
+
+
9
Hide selected columns
+
0
Unhide selected columns
+
+
0

Use function key shortcuts

Display the Help window
F1
Edit the selected cell
F2
Insert a note or open and edit a cell note
+
F2
Insert a threaded comment or open and reply to a threaded comment
+
+
F2
Open the Save dialog box
+
F2
Open the Formula Builder
+
F3
Open the Define Name dialog box
+
F3
Close a window or a dialog box
+
F4
Display the Go To dialog box
F5
Display the Find dialog box
+
F5
Move to the Search Sheet dialog box
+
F5
Switch focus between the worksheet, ribbon, task pane, and status bar
F6
or
+
F6
Check spelling
F7
Open the thesaurus
+
F7
or
+
+
+
R
Extend the selection
F8
Add to the selection
+
F8
Display the Macro dialog box
+
F8
Calculate all open workbooks
F9
Calculate the active sheet
+
F9
Minimize the active window
+
F9
Display the context menu, or "right click" menu
+
F10
Display a pop-up menu (on object button menu), such as by clicking the button after you paste into a sheet
+
+
F10
Maximize or restore the active window
+
F10
or
+
F10
Insert a new chart sheet.*
F11
Insert a new sheet.*
+
F11
Insert an Excel 4.0 macro sheet
+
F11
Open Visual Basic
+
F11
Display the Save As dialog box
F12
Display the Open dialog box
+
F12
Open the Power Query Editor
+
F12

Drawing

Toggle Drawing mode on and off
+
+
Z

Why should you learn shortcuts?

Work Twice as Fast
Forget the menus. Shortcuts save seconds — and add up to hours of real time.
Stay in the Flow
Clicks break focus. Shortcuts keep your rhythm steady and ideas moving.
Be a Real Pro
Master your tools. Work with precision, speed, and confidence.
Don’t Fall Behind AI
AI moves at light speed — you can too. Learn shortcuts or stay stuck clicking.
Train Your Brain
Shortcuts boost focus, memory, and reflexes — real digital mental fitness.
More Power, Less Effort
Stay in control. Get more done every day — without burning out or slowing down.