82 Keyboard Shortcuts for Excel YOU Need + (PDF Cheat Sheet)

Last Updated: January 10, 2024

Knowing and using Keyboard Shortcuts is one of those Excel Skills that can help you save a ton of time every day. There are more than 500 keyboard shortcuts that you can use in Excel, but the problem is not all of those can be helpful for you.

That’s why I have listed only the 82 most important keyboard shortcuts that you can learn and use easily. If somehow you are not able to find a keyboard shortcut for the option that you use frequently in your work, you can use the following method to find it.

Super Tips

  • Replace your 10 most used options with shortcuts.
  • Make your fingers learn the shortcut keys.

Most Amazing Keyboard Shortcuts for Excel

Navigation

Ctrl + →

Move Right

Ctrl + ←

Move Left

Ctrl + ↓

Move Down

Ctrl + ↑

Move Up

Options

F1

Help

Menu Button

Right Click Menu

Ctrl + T

Apply Table

Alt ⇢ H ⇢ J

Cell Style

Alt ⇢ N ⇢ V

Insert a Pivot

Alt ⇢ N ⇢ T

Appy an Excel Table

Alt ⇢ M ⇢ N

Name Manager

Alt ⇢ D ⇢ F ⇢ F

Add Filters

Alt ⇢ A ⇢ V ⇢ V

Add Data Validation

Alt ⇢ A ⇢ M

Remove Duplicates

Alt ⇢ A ⇢ R ⇢ A

Refresh All

Alt ⇢ A ⇢ E

Text to Column

Alt ⇢ A ⇢ G

Group

Alt ⇢ A ⇢ U

Ungroup

Alt ⇢ A ⇢ U

Add Subtotal

Alt ⇢ A ⇢ S ⇢ S

Open Sort

View

Alt ⇢ W ⇢ V ⇢ F

Hide Formula Bar

Alt ⇢ W ⇢ V ⇢ H

Hide Heading

Alt ⇢ W ⇢ V ⇢ G

Hide Gridlines

Alt ⇢ W ⇢ Q ⇢ C

Change Zoom

Alt ⇢ W ⇢ F ⇢ F

Freeze Pane

Alt ⇢ W ⇢ I

Page Break View

Alt ⇢ W ⇢ F ⇢ C

Custom View

Alt ⇢ W ⇢ F ⇢ P

Page Layout View

Alt ⇢ W ⇢ A

Arrange Windows

Basic Operations

Ctrl + C

Copy

Ctrl + V

Paste

Ctrl + X

Cut

Ctrl + S

Save

Ctrl + F4

Save As

Ctrl + P

Print Preview

Ctrl + Z

Undo

Ctrl + Y

Redo

Formatting

F1

Bold

Menu Button

Italic

Alt ⇢ H ⇢ L ⇢ N

Underline

Ctrl + T

Format Option

Alt ⇢ H ⇢ J

Apply Time Format

Alt ⇢ N ⇢ V

Apply Date Format

Alt ⇢ N ⇢ T

Apply Currency Format

Alt ⇢ M ⇢ N

Apply Percent Format

Alt ⇢ D ⇢ F ⇢ F

Adjust Cell Width

Alt ⇢ A ⇢ V ⇢ V

Apply Border

Alt ⇢ A ⇢ M

Change Font Color

Alt ⇢ A ⇢ R ⇢ A

Change Cell Color

Alt ⇢ A ⇢ E

Align Text to the Center

Alt ⇢ A ⇢ G

Merge Cell

Alt ⇢ A ⇢ U

Wrap Text

Alt ⇢ A ⇢ U

Change Font Style

Alt ⇢ A ⇢ S ⇢ S

Change Font Size

Alt ⇢ H ⇢ L ⇢ N

Conditional Formatting

Range

Ctrl + A

Select All

Ctrl + Space

Select Column

Shift + Space

Select Row

Delete

Delete

F2

Edit a Cell

Esc

Close Edit More

Insert

Alt ⇢ N ⇢ P

Insert a Picture

Alt ⇢ N ⇢ S ⇢ H

Insert a Shape

Alt ⇢ N ⇢ S ⇢ C

Insert Charts

Alt ⇢ N ⇢ I

Insert Hyperlink

Alt ⇢ N ⇢ X

Insert Text Box

Alt ⇢ N ⇢ J

Insert Object

Alt ⇢ N ⇢ U

Insert Symbol

Alt ⇢ N ⇢ H

Insert a Header

Alt ⇢ N ⇢ Z ⇢ K

Open Sparklines

Functions

Shift + F3

Insert Function

Alt ⇢ M ⇢ R

Recent Functions

Alt ⇢ M ⇢ I

Finance Functions

Alt ⇢ M ⇢ L

Logical Functions

Alt ⇢ M ⇢ T

Text Functions

Alt ⇢ M ⇢ E

Date Functions

Alt ⇢ M ⇢ O

Lookup Functions

Alt ⇢ M ⇢ G

Math Functions

Alt ⇢ M ⇢ Q

More Functions

Alt + =

Auto Sum

Helpful Note

When you press the ALT‌ key Excel shows you the keys that you can use to open the tab from the ribbon.

excel-ribbon-with-keyboard-shortcutsexcel-ribbon-with-keyboard-shortcuts

And when you press a key for a particular tab to open it further shows you the keys to open the options that you have on that tab, so one for further dropdowns.

excel-ribbon-press-alt-and-further-key

Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, and Excel 365