Download MS Excel Shortcut Keys Pdf Free

 

EXCEL  SHORTCUT KEYS

Shortcut Keys

Description

F2

Edit the selected cell

F5

Go to a specific cell

F7

Spell check selected text and/or document

F11

Create chart

Ctrl + Shift + ;

Enter the current time

Ctrl + ;

Enter the current date

Alt + Shift + F1

Insert new worksheet

Shift + F3

Open the Excel formula window

Shift + F5

Bring up search box

Ctrl + A

Select all contents of worksheet

Ctrl + B

Bold highlighted selection

Ctrl + I

Italicize highlighted selection

Ctrl + C

Copy selected text

Ctrl + V

Paste

Ctrl + D

Fill

Ctrl + K

Insert link

Ctrl + F

Open find and replace options

Ctrl + G

Open go-to options

Ctrl + H

Open find and replace options

Ctrl + U

Underline highlighted selection

Ctrl + Y

Underline selected text

Ctrl + 5

Strikethrough highlighted selection

Ctrl + O

Open options

Ctrl + N

Open new document

Ctrl + P

Open print dialog box

Ctrl + S

Save

Ctrl + Z

Undo last action

Ctrl + F9

Minimize current window

Ctrl + F10

Maximize currently selected window

Ctrl + F6

Switch between open workbooks/windows

Ctrl + Page up & Page Down

Move between Excel® worksheets in the same document

Ctrl + Tab

Move between two or more open Excel® files

Alt + =

Create formula to sum all of above cells

Ctrl + ‘

Insert value of above cell into current cell

Ctrl + Shift + !

Format number in comma format

Ctrl + Shift + $

Format number in currency format

Ctrl + Shift + #

Format number in date format

Ctrl + Shift + %

Format number in percentage format

Ctrl + Shift + ^

Format number in scientific format

Ctrl + Shift + @

Format number in time format

Ctrl + 🡒

Move to next section of text

Ctrl + Space

Select entire column

Shift + Space

Select entire row

Ctrl + W

Close document