Microsoft Excel Shortcut Keys

Microsoft Excel Shortcut Keys

DESCRIPTION OF SHORTCUT	SHORTCUT KEYS
Open New Excel Workbook	CTRL + N
Create New Sheet	ALT + SHIFT + F1
Open File	CTRL + F12
Save workbook	CTRL + S
Save As	F12
Copy	CTR L+ C
Pest	CTRL + V
Bold	CTRL + B OR CTRL + @
Italic	CTRL + I OR CTRL + #
Underline	CTRL + U OR CTRL + $
Strikethrough Example	CTRL + %
Quik Open Font Format Cell	CTRL + SHIFT + F
Copy Above Cell	CTRL + D
Print	CTRL + P
Undo	CTRL + Z
Redo	CTRL + Y
All Borders	First Select cells Range and press ALT + H + B + A
Outside Borders	First Select cells Range and press ALT + H + B + S
Remove All Borders	First Select cells Range and press ALT + H + B + N
Merge and Center Cells	First Select cells Range and press ALT + H + M + C
Merge Cells	First Select cells Range and press ALT + H + M + M
Unmerge Cells	First Select cells Range and press ALT + H + M + U
Value Pest	First copy text that you want & press ALT + E + S + V
Format Pest	First copy format that you want & press ALT + E + S + T
Coment Pest	First copy commet that you want & press ALT + E + S + C
Formula Pest	First copy formula that you want & press ALT + E + S + F
Find	CTRL + F
Replace	CTRL + F > ALT + P
Close Existing Excel Workbook	ALT + F + C or ALT F4
Close All Excel Workbook	ALT + F + X
Move between multipal Workbook	ALT + Tab
Move between multipal sheet	CTRL + Page Down to move forward CTRL + Page Up to move Backward
Write below in same cell	First select cell and press ALT + ENTER
Go to End	CTRL + End
Go to A1 Cell	CTRL + Home
Go to Up in Existing Columns	CTRL + Up key ↑
Go to Down in Existing Columns	CTRL + Down key ↓
Go to Left in Existing Rows	CTRL + Left key ←
Go to Right in Existing Rows	CTRL + Right key →
Select All	CTRL + A
Select Column	CTRL + Space bar
Select Rows	Shift + Space bar
Add Column	CTRL + Space bar and CTRL + (+) Button
Add Rows	Shift + Space bar and CTRL + (+) Button
Delete Column	CTRL + Space bar and CTRL + (-) Button
Delete Rows	Shift + Space bar and CTRL + (-) Button
Hide Column	CTRL + )
Hide Row	CTRL + (
Go to Any cell	CTRL + G and type cell no in reference and press enter or F5
Take Screen Shot	CTRL + Print Screen and pest where you want
Apply Filter	Shift + Space Bar and press CTRL + SHIFT + L
Remove Filter	Shift + Space Bar and press CTRL + SHIFT + L
Sum	First go at the end of the number list and press Alt + (=) button and press enter
Auto Adjust Column Width	CTRL + Space Bar and ALT + O + C + A
Auto Adjust Row Width	Shift + Space Bar and ALT + O + R + A
Show All formula in Sheet	CTRL + ` OR CTRL + ~
Quik Open Number Format Cell	CTRL + !
Open help Menu	F1
Edit Selected Cell	F2
Pest Cell Name	F3
Repeat Last Action	F4 Ex. If you change colour of any cell and you want to repeat same action in other cell press F4
Spelling Check	F7
Move to Next Pane	F6
Enter Extend Mode	F8
Recalculate Every Workbook	F9
Activate Menu Bar	F10
Create Chart form Selected Data	F11
Insert Chart	ALT + F1
Minimize Current Window	CTRL + F9
Restore Down or Maximize Current Window	CTRL + F10
Previous Workbook	CTRL + SHIFT +F6
Next Workbook	CTRL + F6