Related links

MS EXCEL shortcut keys

GENERAL SHORTCUT KEYS

New file Ctrl + N
Open file Ctrl + O
Save file Ctrl + S
Move between open workbooks Ctrl + Tab
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 / Refresh F9

NAVIGATING SHORTCUT KEYS

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

 

Formatting Text in worksheet

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

 

Highlighting Cells in worksheet

Select entire worksheet Ctrl + A
Select entire row Shift + Spacebar
Select entire column Ctrl + Spacebar
Manual select Shift + Arrow Key

 

 

Formatting Cells in worksheet

Format cells Ctrl + 1
Format as number Ctrl + Shift + 1
Format as date Ctrl + Shift + 3
Format as currency Ctrl + Shift + 4
Format as percentage Ctrl + Shift + 5

 

 

Editing/Deleting Text

Delete one character to right Delete
Delete one character to left Backspace
Edit active cell F2
Cancel cell entry Escape Key

 

INSERTING TEXT AUTOMATICALLY

Autosum a range of cells Alt + Equals Sign
Insert the date Ctrl + ; (semi-colon)
Insert the time Ctrl + Shift + ; (semi-colon)
Insert columns/rows Ctrl + Shift + "+" (plus sign)
Insert a new worksheet Shift + F11
Delete columns/rows Ctrl + Shift + "- "

 

Current time

Custom Search