Microsoft Excel shortcut keys
The keys for navigating and working with Excel sheets to stay
productive and quicker in actions to perform. The below list is valid for all
Microsoft Excel versions Excel 2016, Excel 2013, Excel
2010, Excel 2007, Excel 2003.
Shortcuts
|
Functions
|
CTRL+A
|
Select All
|
CTRL+B
|
Bold
|
CTRL+C
|
Copy
|
CTRL+D
|
Fill Down
|
CTRL+F
|
Find
|
CTRL+G
|
Go To
|
CTRL+H
|
Replace
|
CTRL+I
|
Italic
|
CTRL+K
|
Insert Hyperlink
|
CTRL+N
|
New Workbook
|
CTRL+O
|
Open File
|
CTRL+P
|
Print
|
CTRL+R
|
Fill Right
|
CTRL+S
|
Save Workbook
|
CTRL+T
|
Create Table
|
CTRL+U
|
Underline
|
CTRL+V
|
Paste
|
CTRL+W
|
Close Window
|
CTRL+X
|
Cut
|
CTRL+Y
|
Repeat
|
CTRL+Z
|
Undo
|
CTRL+1
|
Format Box
|
CTRL+5
|
Strike Through
|
CTRL+9
|
Hide Row
|
SHIFT+CTRL+9
|
Unhide Row
|
CTRL+0
|
Hide Column
|
SHIFT+CTRL+0
|
Unhide Column
|
CTRL+~
|
Show Formulas or
Values
|
CTRL+'
|
Copy Above
Formula
|
CTRL+[
|
Precedents
|
CTRL+]
|
Dependents
|
CTRL+;
|
Display Dates
|
SHIFT+CTRL+;
|
Display Time
|
CTRL+Space
|
Select Column
|
CTRL + Enter
|
Fill Selection
|
ALT+H+M+C
|
Merge &
Center
|
ALT+H+M+A
|
Merge Across
|
ALT+H+M+U
|
Unmerge Cells
|
Please update the excel training series for beginner's.
ReplyDeleteThanks for your message. The training series will start soon.
ReplyDelete