200+ Excel Keyboard Shortcuts – 10x Your Productivity

Excel Keyboard Shortcuts

There is no shortcut to success. Well.. there is when it comes to Excel.

Here is a list of 200+ Excel Keyboard Shortcuts that will save you tons of time.

Click on the categories below, or scroll down to see all the Excel Keyboard Shortcuts.

200+ Excel Keyboard Shortcuts
Excel Keyboard Shortcuts – Workbook
Create a new blank Workbook.
Ctrl
N
Displays the Open Dialogue box to Open/Find a file.
Ctrl
O
Saves the Workbook with its current file name, location, and file type.
Ctrl
S
Opens the Save As dialogue box.
F12
Opens the Print Preview Window.
Ctrl
F2
Maximize or Restore Selected Workbook Window.
Ctrl
F10
Minimize Workbook.
Ctrl
F9
Switch to the Next Workbook.
Ctrl
Tab
Switch to the Previous Workbook.
Ctrl
Shift
Tab
Close Current Workbook.
Alt
F4
Back
Excel Keyboard Shortcuts – Cell Editing
Edit Active Cell.
F2
Start a New Line in the Same Cell.
Alt
Enter
Select One Character on the Right of the Cursor.
Shift
Select One Character on the Left of the Cursor.
Shift
Jump one Word on the Right of the Cursor.
Ctrl
Jump one Word on the Left of the Cursor.
Ctrl
Select one Word on the Right of the Cursor.
Ctrl
Shift
Select one Word on the Left of the Cursor.
Ctrl
Shift
Delete One Character on the Left of the Cursor.
Backspace
Delete Character on the Right of the Cursor.
Delete
Delete to the End of the line (from the cursor).
Ctrl
Delete
Cancel Entry.
Esc
Back
Move One Cell Up.
Move One Cell Down.
Move One Cell to the Right.
Move One Cell to the Left.
Down One Screen.
PageDown
Up One Screen.
PageUp
Move One Screen to the Right.
Alt
PageDown
Move One Screen to the Left.
Alt
PageUp
Move to the Right Edge of the Data Region.
Ctrl
Move to the Left Edge of Data Region.
Ctrl
Move to Bottom edge of data region.
Ctrl
Move to the Top Edge of Data Region.
Ctrl
Move to the Bottom-right used Cell in the Worksheet.
Ctrl
End
Go to the First Cell in the Current Region.
Ctrl
Home
Move to the Beginning of the Row.
Home
Move to Next Worksheet.
Ctrl
PageDown
Move to Previous Worksheet.
Ctrl
PageUp
Back
Excel Keyboard Shortcuts – General
Opens Help.
F1
Repeats the last command or action.
Ctrl
Y
Repeats Last Action.
F4
Undo.
Ctrl
Z
Spell Check.
F7
Apply Data Filter.
Ctrl
Shift
L
Activate Filter (when the cell with filter is selected).
Alt
Display Go To Dialogue Box.
F5
Display Go To Dialogue Box.
Ctrl
G
Recalculate All Workbooks.
F9
Calculate Active Worksheet.
Shift
F9
Display the Print Menu.
Ctrl
P
Turn On End Mode.
End
Back
Excel Keyboard Shortcuts – Cut, Copy, Paste
Copy Selected Cells.
Ctrl
C
Cut Selected Cells.
Ctrl
X
Paste Content from the Clipboard.
Ctrl
V
Copy Formula from the Cell Above.
Ctrl
'
Copy Value from the Cell Above.
Ctrl
"
Display Paste Special Dialogue Box.
Ctrl
Alt
V
Back
Excel Keyboard Shortcuts – Data Entry
Enter and Move Down.
Enter
Enter and Remain on the Same Cell.
Control
Enter
Enter and Move Up.
Shift
Enter
Enter and Move right.
Tab
Enter and Move Left.
Shift
Tab
Enter Same Data in All Selected Cells.
Control
Enter
Display AutoComplete list.
Alt
Fill Down.
Ctrl
D
Fill Right.
Ctrl
R
Insert Current Date.
Ctrl
;
Insert Current Time.
Ctrl
Shift
;
Start a New Line in the Same Cell.
Alt
Enter
Cancel Cell Entry.
ESC
Back
Excel Keyboard Shortcuts – Clear
Clear Everything.
Alt
H
E
A
Clear Formats Only.
Alt
H
E
F
Clear Content Only.
Alt
H
E
C
Clear Hyperlinks Only.
Alt
H
E
L
Clear Comments Only.
Alt
H
E
M
Back
Excel Keyboard Shortcuts – Selection
Select the Current Region / Select All.
Ctrl
A
Select Visible Cells in the Current Region.
Alt
;
Select the Current Region Around the Active Cell.
Ctrl
Shift
*
Select Entire Row.
Shift
Space
Select Entire Column.
Ctrl
Space
Select All Cells that Contain Comments.
Ctrl
Shift
O
Select Row Differences.
Ctrl
\
Select Column Differences.
Ctrl
Shift
|
Select Direct Precedents.
Ctrl
[
Select all Precedents.
Ctrl
Shift
{
Select Direct Dependents.
Ctrl
]
Select all Dependents.
Ctrl
Shift
}
Display Go To Dialogue Box.
Ctrl
G
Back
Excel Keyboard Shortcuts – Extending the Selection
Extend Selection to the Right by One Cell.
Shift
Extend Selection to the Left by One Cell.
Shift
Extend Selection Upwards by One Cell.
Shift
Extend Selection Downwards by One Cell.
Shift
Extend the Selection to the Right till the Last Cell.
Ctrl
Shift
Extend the Selection to the Left till the Last Cell.
Ctrl
Shift
Extend the Selection Upwards to the Last Cell.
Ctrl
Shift
Extend Selection Upwards by One Screen.
Shift
PageUp
Extend Selection Downwards by One Screen.
Shift
PageDown
Extend Selection to the Right by One Screen.
ALT
Shift
PageUp
Extend Selection to the Left by One Screen.
ALT
Shift
PageDown
Extend Selection to the Start of the Row.
Shift
Home
Extend Selection to First Cell in the Worksheet.
Ctrl
Shift
Home
Extend Selection to the Last Cell in the Worksheet.
Ctrl
Shift
End
Toggle Extend Selection Mode.
F8
Back
Excel Keyboard Shortcuts – Alignment
Align Content to the Center of the Cell.
Alt
H
A
C
Align Content to the Left of the Cell.
Alt
H
A
L
Align Content to the Right of the Cell.
Alt
H
A
R
Align Content to the Middle of the Cell.
Alt
H
A
M
Back
Excel Keyboard Shortcuts – Hide/Unhide (Rows, Columns, Objects)
Hide Selected Rows.
Ctrl
9
Hide Selected Columns.
Ctrl
0
Unhide Hidden Rows in Selection.
Ctrl
Shift
9
Unhide Hidden Columns in Selection.
Ctrl
Shift
0
Show/Hide Objects.
Ctrl
6
Back
Excel Keyboard Shortcuts – Insert
Insert New Line in Same Cell.
Alt
Enter
Insert New Worksheet.
Shift
F11
Insert Row/Cell (shows dialogue box).
Ctrl
Shift
=
Insert Current Date.
Ctrl
;
Insert Current Time.
Ctrl
Shift
;
Insert Table.
Ctrl
T
Insert Hyperlink.
Ctrl
K
Insert Argument Names into Formula.
Ctrl
Shift
A
Insert/Edit Cell Comment.
Shift
F2
Delete Row/Cell (shows dialogue box).
Ctrl
-
Back
Excel Keyboard Shortcuts – Formatting
Make Text Bold.
Ctrl
B
Make Text Italics.
Ctrl
I
Place outline Border around the Selected Cells.
Ctrl
Shift
7
Remove Outline Border.
Ctrl
Shift
_
Underline Text.
Ctrl
U
Apply Strikethrough Format.
Ctrl
5
Apply Indent.
Alt
H
6
Remove Indent.
Alt
H
5
Increase Font Size by One Step.
Alt
H
F
G
Decrease Font Size by One Step.
Alt
H
F
K
Apply the Number format with Two Decimal Places, Thousands Separator, and a Minus Sign for Negative Values.
Ctrl
Shift
!
Apply the Date format with the Day, Month, and Year.
Ctrl
Shift
#
Apply the Currency Format with Two Decimal Places.
Ctrl
Shift
$
Apply the Percentage Format with No Decimal Places.
Ctrl
Shift
%
Apply the Time format with the Hour and Minute, and indicate A.M. or P.M.
Ctrl
Shift
@
Apply the General Number Format.
Ctrl
Shift
~
Apply the Exponential Format.
Ctrl
Shift
^
Displays the Format Style Dialog Box.
Alt
'
Displays the Format Cells Dialogue Box.
Ctrl
1
Displays the Font Dialogue Box.
Shift
Ctrl
F
Back
Excel Keyboard Shortcuts – Formula Related
Insert Autosum Formula.
Alt
=
While Typing a Formula, Switches Cell Reference from Absolute to Relative.
F4
Expand/Collapse Formula Bar.
Ctrl
Shift
U
Display the Insert Function Dialog Box.
Shift
F3
Enter a Formula as an Array Formula.
Ctrl
Shift
Enter
Evaluate Part of the Formula.
F9
Select the Array Containing the Active Cell.
CTRL
/
Select All Cells Directly or Indirectly Referenced by Formulas in the Selection.
CTRL
[
Select Cells that Contain Formulas that Directly or Indirectly Reference the Active Cell.
CTRL
]
Toggle Value/Formula display.
Ctrl
`
Rechecks Dependent Formulas and then Calculates all Cells in all Open Workbooks.
Ctrl
Alt
Shift
F9
Back
Excel Keyboard Shortcuts – Find and Replace
Display Find and Replace Dialogue Box (Find Selected).
Ctrl
F
Display Find and Replace Dialogue Box (Replace Selected).
Ctrl
H
Find Next Match.
Shift
F4
Find Previous Match.
Ctrl
Shift
F4
Back
Excel Keyboard Shortcuts – Conditional Formatting
Open Conditional Formatting Dialogue Box.
Alt
O
D
Clear Conditional from Selected Cells.
Alt
H
L
C
S
Clear Conditional from the Entire Worksheet.
Alt
H
L
C
E
Back
Excel Keyboard Shortcuts – Charting
Inserts Chart in the Worksheet (using the selected data).
Alt
F1
Inserts a ChartSheet with a Chart (using the selected data).
F11
Back
Excel Keyboard Shortcuts – Drag (Mouse)
Drag and Copy.
Ctrl
Drag
Drag and Cut.
Drag
Drag and Insert.
Shift
Drag
Duplicate Worksheet.
Ctrl
Drag
Switch Position of Cells/Rows/Columns.
Ctrl
Shift
Drag
Back
Excel Keyboard Shortcuts – Named Ranges
Get a List of All Defined Named Ranges.
F3
Create Named Range from Selection.
Ctrl
Shift
F3
Define Name Dialog Box.
Ctrl
F3
Back
Excel Keyboard Shortcuts – Pivot Table
Display Insert Pivot Table Dialogue Box.
Alt
N
V
Open Pivot Table Wizard.
Alt
D
P
Select Entire Pivot Table (excluding Report Filters).
Ctrl
A
Add/Remove Checkmark for Selected Field in PivotTable Field List.
Space
Group Selected Pivot Table Items.
Alt
Shift
UnGroup Pivot Table Items.
Alt
Shift
Select the Next Item in PivotTable Field List or Items List.
Select a Previous Item in PivotTable Field List or Items List.
Select Last Visible Item in List.
End
Select First Visible Item in List.
Home
Open Field List for Active Cell.
Alt
Hide Selected Item or Field.
Ctrl
Opens Calculated Field dialog box (when data field is selected).
Shift
Ctrl
=
Opens Calculated Item Dialog box (when field heading cell is Selected).
Shift
Ctrl
=
Back
Excel Keyboard Shortcuts – Others
Restore Window Size.
Ctrl
F5
Move Window.
Ctrl
F7
Resize Window.
Ctrl
F8
Previous Window.
Ctrl
Shift
F6
Next Pane.
F6
Previous Pane.
F8
Extend Mode.
Shift
F10
Display Shortcut Menu.
Shift
F6
Turns On the Add to Selection Mode.
Shift
F8
Back
Excel Keyboard Shortcuts – VBA
Switch between Excel Worksheet and the VBA editor.
Alt
F11
VB Help.
F1
View Object Browser.
F2
View Properties.
F4
View Code window.
F7
View Immediate window.
Ctrl
G
View Shortcut Menu.
Shift
F10
Run a Sub/UserForm.
F5
Step Into.
F8
Step Over.
Shift
F8
Step Out.
Ctrl
Shift
F8
Run to Cursor.
Ctrl
F8
Toggle Breakpoint.
F9
Clear All Breakpoints.
Ctrl
F9
Close VBA Editor and Return to the Excel Worksheet.
Alt
Q
Back

Excel Resources: