200+ Excel Keyboard Shortcuts to Boost Productivity (Windows)

Microsoft Excel is a powerful tool for reporting and analyzing data. But for some, using Excel can be a bit tough. Without proper Excel training, you’ll find it hard to navigate through formulas and spreadsheets.

Creating reports can be time-consuming. If you’re spending too much time on Excel, it might be worth learning a few tricks to be productive at work and meet those deadlines. Consider this list a crash course on Excel’s most essential functions and keyboard shortcuts.

Manage workbooks, format data, work with formulas, navigate between worksheets, and save time with these 200+ handy keyboard shortcuts on Windows:

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

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

Navigation

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

General Shortcuts

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

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 Selected Cells.	Ctrl C
Display Paste Special Dialogue Box.	Ctrl Alt V
Copy Value from the Cell Above.	Ctrl “

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

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

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

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

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

Hide/Unhide (Rows, Columns, Objects)

Hide Selected Rows.	Ctrl 9
Hide Selected Columns.	Ctrl 0
Unhide Hidden Rows in Selection.	Ctrl Shift 9
Hide Selected Columns.	Ctrl 0
Unhide Hidden Columns in Selection.	Ctrl Shift 0
Show/Hide Objects.	Ctrl 6

Insert

Insert New Line in Same Cell.	Alt Enter
Insert New Worksheet.	Shift F11
Insert Row/Cell (shows dialogue box).	Ctrl Shift =
Insert New Line in Same Cell.	Alt Enter
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 –

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
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

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 ]
Rechecks Dependent Formulas and then Calculates all Cells in all Open Workbooks.	Ctrl Alt Shift F9

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

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

Charting

Inserts Chart in the Worksheet (using the selected data).	Alt F1
Inserts a ChartSheet with a Chart (using the selected data).	F11

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

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

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 =

Other shortcuts

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

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