80+ Must Know Excel Shortcuts for Windows

Check with us an absolute must-know Windows Excel Shortcuts!

Have you ever wondered how to work more efficiently in Excel? How to save your time? How to impress your potential employer during a job interview and without words prove that you are fluent in Excel? The answer is simple: use Excel shortcuts!

Top 75 Excel Interview Questions 2021

25 Excel Interview Questions for Business Analyst

40+ Excel Interview Questions for Data Analyst

Today, we would like to share with you over 80 most popular Excel shortcuts for Windows. If you are using Mac, go to our article 80+ Must Know Excel shortcuts for Mac.

In our list, you will find all the best Excel shortcuts, both basic and advanced ones, grouped into several handy categories. At the end of this article, you will also find a list of useful links to learn more and get technical support.

windows excel shortcuts

Most useful Excel shortcuts for Windows

Description Shortcut
Create a new workbook Ctrl + N
Open a workbook Ctrl + O
Close a workbook Ctrl + W
Save a workbook Ctrl + S
Save as F12
Print Ctrl + P
Print preview Ctrl + F2
Copy Ctrl + C
Paste Ctrl + P
Cut Ctrl + X
Undo Ctrl + Z
Redo Ctrl + Y
Find Ctrl + F
Bold Ctrl + B
Italic Ctrl + I
Underline Ctrl + U
Strikethrough Ctrl + 5
Right-click menu Shift + F10
Home tab Alt + H
Insert tab Alt + N
Page Layout tab Alt + P
Data tab Alt + A
View tab Alt + W
Formula tab Alt + M
Delete column Alt + H, D, C
Hide selected rows Ctrl + 9
Hide selected columns Ctrl + 0
Help F1

Ribbon Excel shortcuts (Windows)

Description Shortcut
File page Alt + F
Home tab Alt + H
Insert tab Alt + N
Page Layout tab Alt + P
Formulas tab Alt + M
Data tab Alt + A
Review tab Alt + R
View tab Alt + W
Select active tab on the Ribbon Alt or F10
Move to the next Ribbon control Tab key

or

Shift + Tab

Navigate among the items on the Ribbon Arrow keys
Activate a selected button Spacebar

or

Enter

Expand/Collapse the Ribbon Ctrl + F1
Right-click menu Shift + F10

Excel shortcuts for navigating in cells (Windows)

Description Shortcut
Previous cell in a worksheet Shift + Tab
Navigate among the cells Arrow keys
Beginning of a worksheet Ctrl + Home
Next sheet in a workbook Ctrl + Page Down
Previous sheet in a workbook Ctrl + Page Up
Zoom in Ctrl + Alt + +
Zoom out Ctrl + Alt + –
Zoom scroll Ctrl + Scroll
Start a new line in the cell Alt + Enter
Select all (the entire worksheet) Ctrl + A
Select the entire column Ctrl + Spacebar
Select the entire row Shift + Spacebar
Cancel selection Esc

Excel shortcuts for formatting cells (Windows)

Description Shortcut
Format Cell dialog Ctrl + 1
Fonts formatting Ctrl + Shift + F

or

Ctrl + Shift + P

Insert/Open/Edit a cell note Shift + F2
Insert/Open/Reply to a threaded comment Ctrl + Shift + F2
Insert cells Ctrl + Shift + +
Delete cells Ctrl + –
Hide columns Ctrl + 0
Hide rows Ctrl + 9
Unhide columns Ctrl + Shift + 0
Unhide rows Ctrl + Shift + 9
Copy Ctrl + C
Paste Ctrl + P
Cut Ctrl + X
Undo Ctrl + Z
Redo Ctrl + Y
Find Ctrl + F
Bold Ctrl + B
Italic Ctrl + I
Underline Ctrl + U
Strikethrough Ctrl + 5
Insert hyperlink Ctrl + K
Check spelling F7

Other useful Excel shortcuts (Windows)

Description Shortcut
Insert a table Ctrl + T
Insert a function Shift + F3
Create an embedded chart Alt + F1
Create a chart in a new worksheet F11
Create/Run/Edit/Delete a macro Alt + F8
VBA Editor Alt + F11
Refresh the data in the current worksheet Ctrl + F5
Refresh the data in the whole workbook Ctrl + Alt + F5
Duplicate object Ctrl + D

Windows Excel Shortcuts PDF Download

Excel shortcuts pdf

Useful links

To learn more about Excel shortcuts and get technical support, go to support.microsoft.com

To remember and practice Excel shortcuts and commands, check ShortcutFoo app

“Excel Shortcuts: The 100 Top Best Powerful Excel Keyboard Shortcuts in 1 Day!” by Sam Key

MS Office Certification guide

Was this helpful?

0 / 0

Leave a Reply 0

Your email address will not be published. Required fields are marked *


error: Content is protected !!