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