Top 50 Keyboard Shortcuts for Excel

Ctrl + C

Copy

Ctrl + V

Paste

Ctrl + X

Cut

Ctrl + Z

Undo

Ctrl + Y

Redo

Ctrl + S

Save

Ctrl + A

Select all

Ctrl + F

Find

Ctrl + H

Find and Replace

Ctrl + P

Print

Ctrl + N

New workbook

Ctrl + O

Open workbook

Ctrl + W

Close workbook

Ctrl + Tab

Switch workbooks

Alt + Tab

Switch applications

Ctrl + Arrow Key

Jump to edge of data

Ctrl + Home

Go to cell A1

Ctrl + End

Go to last used cell

Home

Go to beginning of row

Ctrl + Page Up

Previous worksheet

Ctrl + Page Down

Next worksheet

F5 or Ctrl + G

Open Go To dialog

Shift + Arrow

Extend selection

Ctrl + Shift + Arrow

Select to edge of data

Ctrl + Space

Select entire column

Shift + Space

Select entire row

Ctrl + Shift + Space

Select entire worksheet

F2

Edit active cell

Delete

Clear cell contents

Ctrl + D

Fill down

Ctrl + R

Fill right

Ctrl + Enter

Fill selected cells with same value

Alt + Enter

New line inside a cell

F4

Repeat last action or cycle cell references in formulas

Ctrl + `

Show or hide formulas

Ctrl + 1

Open Format Cells dialog

Ctrl + B

Bold

Ctrl + I

Italic

Ctrl + U

Underline

Ctrl + Shift + $

Apply Currency format

Ctrl + Shift + %

Apply Percent format

Ctrl + Shift + #

Apply Date format

Ctrl + Shift + !

Apply Number format

Ctrl + Shift + ~

Apply General format

Ctrl + T

Create Excel Table

Ctrl + Shift + L

Toggle filters

Alt + Down Arrow

Open filter dropdown

Alt + =

AutoSum

F9

Recalculate workbook

Shift + F11

Insert new worksheet

Ctrl +

Ctrl + Shift + +

Insert rows, columns, or cells

Tab

Auto

Ctrl + Shift + A

Insert function argument names

Ctrl + [

Go to precedent cells

Ctrl + ]

Go to dependent cells