Shortcut Keys

Excel shortcuts will help you: Increase your modelling productivity, saving time and therefore money. Reduced your dependence on the computer mouse.

Important shortcut keys have been given below for daily use-

General 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

Navigating Shortcuts:

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

Text formatting Shortcuts:

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

Cell formatting Shortcuts:

Format cells Ctrl + 1
Select font Ctrl + Shift + F
Select point size Ctrl + Shift + P
Format as Number Ctrl + Shift + 1
Format as Time Ctrl + Shift + 2
Format as Date Ctrl + Shift + 3
Format as currency Ctrl + Shift + 4
Format as percentage Ctrl + Shift + 5

Highlighting Cells Shortcuts:

Select entire worksheet Ctrl + A
Select entire row Shift + Spacebar
Select entire column Ctrl + Spacebar
Manual select Hold Shift + with Left, Right, Up, Down Arrow Key

Copying and Moving Text Shortcuts:

Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V

Inserting Text Automatically Shortcuts:

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

Misc. Shortcuts:

Find text Ctrl + F
Replace text dialog Ctrl + H
Create a chart automatically on new sheet F11
Edit a cell comment Shift + F2