50 Excel Shortcuts That You Should Know in 2022: MS Excel Short-Cut Keys

Formatting
Short-cut Key

CTRL+1

Format Box

ALT+E+S+T

Copy Format

ALT+H+0

Increase
Decimal

ALT+H+9

Decrease
Decimal

CTRL + SHIFT
+ 7

Boxing

ALT + O + C +
A

Fit Column
width

ALT + H + O +
R

Change Tab
Name

SHIFT + CTRL
+ #

Date Format

SHIFT + CTRL
+ $

Dollar Format

SHIFT + CTRL
+ %

Percentage
Format

ALT +
“=”

Sum function

Ctrl Short-Cut
Keys

CTRL+ A

Select All

CTRL + B

Bold

CTRL + C

Copy

CTRL + D

Fill Down

CTRL + F

Find

CTRL + I

Italic

CTRL + N

New workbook

CTRL + O

Open

CTRL + P

Print

CTRL + R

Fill Right

CTRL + S

Save Workbook

CTRL + U

Underline

CTRL + V

Paste

CTRL + W

Close Window

CTRL + X

Cut

CTRL + Y

Undo

Function
Key Shortcut Keys

F2

Edit Cells

F4

Anchor Cells

F7

Spell Check

F12

Save As

SHIFT + F2

Insert a
Comment

SHIFT + F8

Add to
Selection

SHIFT + F10

Right Click

CTRL + F3

Name a Cell

Windows Flag
+ D

Minimize
Programs

Columns
and Rows Short-Cut Keys

CTRL + 9

Hide Row

SHIFT +CTRL +
9

Unhide Row

CTRL + 0

Hide Column

SHIFT + CTRL
+ 0

Unhide Column

SHIFT +
Spacebar

Highlight
Entire Row

CTRL +
Spacebar

Highlight Entire
Column

SHIFT + CTRL
+ Plus sign

Insert Blank
Cells

CTRL + Minus
Sign

Delete
Selected Cells

SHIFT + ALT +
Left Arrow

Group
Rows/Columns

SHIFT + ALT +
Right Arrow

Ungroup
Rows/Columns