Home / Apps / Microsoft Excel

Microsoft Excel

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

Frequently used shortcuts

Go to a specific cell
Ctrl +
G
Move down
Pg Dn
or
Move up
Pg Up
or
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
+
F3
Apply bold formatting
Ctrl +
B
Open the context menu
+
F10
or
Jump to Search or Tell me
Alt +
Q
Repeat Find downward
+
F4
Repeat Find upward
Ctrl +
+
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
Alt +
,
Q
Open the File menu
Alt +
,
F
Open the Home tab and format text and numbers or use other tools such as Sort & Filter
Alt +
,
H
Open the Insert tab and insert a function, table, chart, hyperlink, or threaded comment
Alt +
,
N
Open the Data tab and refresh connections or use data tools
Alt +
,
A
Open the Review tab and use the Accessibility Checker or work with threaded comments and notes
Alt +
,
R
Open the View tab to choose a view, freeze rows or columns in your worksheet, or show gridlines and headers
Alt +
,
W

Work in the ribbon tabs and menus

Select the active tab of the ribbon and activate the access keys
Alt +
Move the focus to commands on the ribbon
,
or
,
+
Activate a selected button or open the list for a selected command
or
Open the menu for a selected button
Alt +
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
Alt +
,
H,
I,
R
Insert a column to the left of the current column
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 +
Insert a hyperlink
Ctrl +
K
Insert a table
Ctrl +
L
Insert a function
+
F3
Increase font size
Ctrl +
+
.
Decrease font size
Ctrl +
+
,
Apply a filter
Alt +
,
A,
T
Re-apply a filter
Ctrl +
Alt +
L
Toggle AutoFilter on and off
Ctrl +
+
L

Keyboard shortcuts for entering data

Complete cell entry and select the cell below
Complete cell entry and select the cell above
+
Complete cell entry and select the next cell in the row
Complete cell entry and select the previous cell in the row
+
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
Clear the selected cell and start editing
Go to beginning of cell line
Home
Go to end of cell line
End
Select right by one character
+
Select to the beginning of cell data
+
Home
Select to the end of cell data
+
End
Select left by one character
+
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 +
+
or
Ctrl +
+
Insert the current date
Ctrl +
;
Insert the current time
Ctrl +
+
;
Copy a formula from the cell above
Ctrl +
'
Copy the value from the cell above
Ctrl +
+
'
Insert a formula argument
Ctrl +
+
A

Keyboard shortcuts for formatting cells

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

Keyboard shortcuts for moving and scrolling within worksheets

Move up one cell
or
+
Move down one cell
or
Move right one cell
or
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 down one screen (28 rows)
Pg Dn
Move up one screen (28 rows)
Pg Up
Move to the edge of the current data region
Ctrl +
or
Ctrl +
Move between ribbon and workbook content
Ctrl +
F6
Move to a different ribbon tab
Insert a new sheet
+
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

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

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

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

Keyboard shortcuts for moving within a selected range

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

Keyboard shortcuts for calculating data

Calculate workbook (refresh)
F9
Perform full calculation
Ctrl +
+
Alt +
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 +
+
F6
Move within a landmark region
or
+
Go to the Search or Tell Me field to run any command
Alt +
Q
Display or hide Key Tips or access the ribbon
Alt +
Edit the selected cell
F2
Go to a specific cell
Ctrl +
G
Move to another worksheet in the workbook
Ctrl +
Alt +
Pg Up
or
Ctrl +
Alt +
Pg Dn
Open the context menu
+
F10
or
Read row header
Ctrl +
+
Alt +
T
Read row until an active cell
Ctrl +
+
Alt +
Home
Read row from an active cell
Ctrl +
+
Alt +
End
Read column header
Ctrl +
+
Alt +
H
Read column until an active cell
Ctrl +
+
Alt +
Pg Up
Read column from an active cell
Ctrl +
+
Alt +
Pg Dn
Open a list of moving options within a dialog box
Ctrl +
Alt +

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.