EXCEL KEYBOARD SHORTCUTS

New file =     Ctrl + N

Open file =     Ctrl + O

Save file =     Ctrl + S

Move between open workbooks =     Ctrl + F6

Close file =     Ctrl + F4

Save as =     F12

Display the print menu =     Ctrl + P

Select whole spreadsheet =     Ctrl + A

Select column =     Ctrl + Space

Select row =     Shift + Space

Undo last action =     Ctrl + Z

Redo last action =     Ctrl + Y

Exit Excel =     Alt + F4

Spell Check =     F7

Cut =     Ctrl + X

Copy =     Ctrl + C

Paste =     Ctrl + V

Find text =     Ctrl + F

Recalculate =     F9

Move to next cell in row =     Tab

Move to previous cell in row =     Shift + Tab

Up one screen =     Page Up

Down one screen =     Page Down

Move to next worksheet =     Ctrl + Page Down

Move to previous worksheet =     Ctrl + Page Up

Go to first cell in data region =     Ctrl + Home

Go to last cell in data region =     Ctrl + End

Data Region Left =     Ctrl + Left Arrow

Data Region Right =     Ctrl + Right Arrow

Data Region Down =     Ctrl + Down Arrow

Data Region Up =     Ctrl + Up Arrow

Select Whole Data Region =     Ctrl + Shift + 8

Move to Next Sheet =     Ctrl + Page Down

Move to Prior Sheet =     Ctrl + Page Up

Access Drop down menu =     Alt + Down/Up Arrow

Zoom in / out =     Ctrl + mouse scroll

Bold toggle for selection =     Ctrl + B

Italic toggle for selection =     Ctrl + I

Underline toggle for selection =     Ctrl + U

Strikethrough for selection =     Ctrl + 5

Change the font =     Ctrl + Shift + F

Change the font size =     Ctrl + Shift + P

Apply outline borders =     Ctrl + Shift + 7

Remove all borders =     Ctrl + Shift + Underline

Wrap text in same cell =     Alt + Enter

Format cells =     Ctrl + 1

Select font =     Ctrl + Shift + F

Select font size =     Ctrl + Shift + P

Format as number =     Ctrl + Shift + 1

Format as date =     Ctrl + Shift + 3

Format as currency =     Ctrl + Shift + 4

Format as percentage =     Ctrl + Shift + 5

Delete one character to right =     Delete

Delete one character to left =     Backspace

Edit active cell =     F2

Cancel cell entry =     Escape Key

Select entire worksheet =     Ctrl + A

Select entire row =     Shift + Spacebar

Select entire column =     Ctrl + Spacebar

Manual select =     Shift + Arrow Key

Autosum a range of cells =     Alt + Equals Sign

Insert the date =     Ctrl + ; (semi-colon)

Insert the time =     Ctrl + Shift + ; (semi-colon)

Insert a new worksheet =     Shift + F11