|
EXCEL SHORTCUTS QUICK REFERENCE WORKBOOK |
|
|||
|
||||
|
||||
|
CTRL + O |
Opens a workbook |
|
||
|
CTRL + N |
Create a new workbook |
|
||
|
CTRL + P |
Displays the print dialog box |
|
||
|
CTRL + S |
save the workbook |
|
||
|
CTRL + W |
Closes the selected workbook |
|
||
|
CTRL + F2 |
Displays print view |
|
||
|
F9 |
Calculates all open workbook |
|
||
|
SHIFT +F9 |
Calculates the active worksheet |
|
||
|
CTRL + F10 |
Maximize / restore workbook |
|
||
|
SHIFT +F11 |
Inserts a new worksheet |
|
||
|
F12 |
Displays the save a as dialog box |
|
||
FORMETING | ||||
|
||||
|
CTRL + SHIFT + ~ |
Applies
general Format |
|
||
|
CTRL + SHIFT + $ |
Applies
currency format with two decimal places |
|||
|
CTRL +SHIFT + % |
Applies
percentage format with no decimal places |
|||
|
CTRL + SHIFT + # |
Applies
date format |
|||
|
CTRL + SHIFT + @ |
Applies
time format |
|||
|
||||
|
NAVIGATION |
|||
|
TAB |
Left cell to right cell |
||
|
SHIFT + TAB |
Right cell to left cell |
||
|
CTRL + G or F5 |
Go to dialog box |
||
|
CTRL + END |
Moves to last used cell |
||
|
CTRL + HOME |
Moves to the first uesd
cell |
||
|
ALT + PAGE DOWN |
Moves one screen to the
right in a worksheet |
||
|
CTRL + PAGE DOWN |
Moves to the next sheet in
a worksheet |
||
|
ALT + PAGE UP |
|
Moves one screen to the
left in a worksheet |
|
|
CTRL + PAGE UP |
Moves to the previous sheet
in a workbook |
||
|
CTRL + ARROW |
Moves to the edgeof the
current data region |
||
|
|||
|
CTRL + SHIFT + ! |
Applies
the Number format with two decimal places, thousands separator |
|
|
CTRL + 1 |
Displays
the format cells box |
GENERAL |
|||||||||||||
|
CTRL + ~ |
Toggles values and formulas |
||||||||||||
|
CTRL + F3 |
Name manager box |
||||||||||||
|
SHIFT + F3 |
Insert function dialog box |
||||||||||||
|
ALT + M + V |
Evaluate formula box |
||||||||||||
|
CTRL + SHIFT + U |
Expand / collapse of the formula bar |
||||||||||||
|
CTRL + F1 |
Displays or hides Ribbon |
||||||||||||
|
CTRL + SHIFT + L |
Applies / removes filter |
||||||||||||
|
ALT + A + Q |
Advanced filter |
||||||||||||
|
ALT + T + O |
Excel Options |
||||||||||||
|
SELECTION |
|||||||||||||
|
CTRL +
A |
Selects
the entire worksheet (Press 3 Times) |
||||||||||||
|
F 8 |
Toggles
extend mode |
||||||||||||
|
CTRL +
SPACEBAR |
Selects
an entire colum |
||||||||||||
|
SHIFT
+ SPACEBAR |
Selects
an entire row |
||||||||||||
|
EDITING |
|
||||||||||||
|
|||||||||||||
|
CTRL + SHIFT + : |
Enteres the current time |
|
|||||||||||
|
CTRL+ ; |
Enteres the current date |
|
|||||||||||
|
CTRL + C |
Copes the selected cell |
|
|||||||||||
|
CTRL + D |
Copies topmost cell of a range into the
cell below |
|
|||||||||||
|
CTRL + R |
Copies leftmost cell of a range into
cell to right |
|
|||||||||||
|
CTRL + F |
Find dialog box |
|
|||||||||||
|
CTRL + H |
Replace dialog box |
|
|||||||||||
|
CTRL + K |
Edit Hiperlink |
|
|||||||||||
|
CTRL + T |
Create Table dialog box |
|
|||||||||||
|
CTRL + V |
Paste |
|
|||||||||||
|
CTRL + ALT + V |
Paste Special Dialog Box |
|
|||||||||||
|
CTRL + X |
Cuts the selected cell |
|
|||||||||||
|
CTRL + Z |
Undoes last action |
|
|||||||||||
|
EDITING |
|||||||||||||
|
SHIFT + F2 |
Adds / edits comment |
||||||||||||
|
F4 |
|
|
Generates absolute and relative
references |
|
|
|
|
|
|||||
|
F7 |
|
|
Spell check |
|
|
|
|
|
|||||
|
ALT + = |
|
|
Autosum |
|
|
|
|
|
|||||
|
ALT + F8 |
|
|
Opens Macro Dialog box |
|
|
|
|
|
|||||
|
ALT + F11 |
|
|
Opens VB Editor |
|
|
|
|
|
|||||
|
ALT + D + P |
|
|
Opens pivot table wizard |
|
|
|
|
|
|||||
|
ALT + A + M |
|
|
Removes duplicates |
|
|
|
|
|
|||||
|
ALT + A + E |
|
|
Text to columns Wizard |
|
|
|
|
|
|||||
|
ALT + ENTER |
|
|
Enters a new line |
|
|
|
|
|
|||||
|
ALT + D + N |
|
|
Date Validation |
|
|
|
|
|
|||||