Very Important Keyboard Shortcuts in MS Excel






Let's learn some useful shortcuts in MS Excel

Ctrl+ Shortcuts
Create New Workbook
Ctrl+N
Opens ‘open’ Dialog box
Ctrl+O
Fill Range to Down
Ctrl+D
Fill Range to Right
Ctrl+R
Cut
Ctrl+X
Copy 
Ctrl+C
Paste 
Ctrl+V
Undo 
Ctrl+Z
Redo
Ctrl+Y
Find
Ctrl+F
Replace
Ctrl+H
Select all
Ctrl+A
Bold
Ctrl+B
Italics 
Ctrl+I
Underline
Ctrl+U
Open the Create Table dialog box
Ctrl+L
Insert a hyperlink
Ctrl+K
Open Print in backstage view
Ctrl+P
Display Quick Analysis options
Ctrl+Q
Ctrl+ shortcuts with numbers
Hide selected Columns
Ctrl+0
Hide selected Rows
Ctrl+9
Display Format Cells Dialog Box
Ctrl+1
Applies or removes strikethrough
Ctrl+5
Displays or hides outline symbols
Ctrl+8
Ctrl+ shortcuts with signs
Toggle between viewing values and formulas in cells
Ctrl+ ~
Delete the selected cells
Ctrl+ –
Unhide any hidden rows in the selection
Ctrl+Shift + (
Unhide any hidden columns in the selection
Ctrl+Shift + )
Select a range of cells
Ctrl+Shift + *
Insert blank cells
Ctrl+Shift + +
Apply Border to Selected Cells
Ctrl+Shift + &
Remove Outline Border
Ctrl+Shift + _
Insert Current Date
Ctrl+ ;
Insert Current Time
Ctrl+Shift + ;
Rotates Active Cell through the corners of selection
Ctrl+ .
Select Direct Precedent Cells
Ctrl+ [
Select all Precedent Cells
Ctrl+Shift+ [
Select Directly Dependent Cells
Ctrl+ ]
Select all Dependent Cells
Ctrl+Shift+ ]
Copy the Value from Above Cell
Ctrl+Shift+ "
Copy the Formula from Above Cell
Ctrl+ ‘
F keys shortcuts
Help 
F1
Expand/Collapse the Ribbon
Ctrl+F1
Edit Active Cells
F2
Open Print Preview
Ctrl+F2
Paste Named Range in Formula
F3
Name Manager Dialog Box
Ctrl+F3
Display Insert Function Dialog Box
Shift+F3
Create Reference 
F4
Go to Dialog Box
F5
Switches between Ribbon Controls
F6
Spell Check
F7
Extend Selection on or off
F8
Calculate Worksheet
F9
Display Ribbon key Letters
F10
Open context menu
Shift+F10
Create a Chart
F11
Insert a New Worksheet
Shift+F11
Save As
F12

More important shortcuts >

Ctrl+ shortcuts and Shift+shortcuts
Move between open workbooks
Ctrl+Tab
Move to Next sheet
Ctrl+Pg Dn
Select Current Sheet and Next Sheet
Ctrl+Shift+PgDn
Move to Previous sheet
Ctrl+Pg Up
Select Current Sheet and Previous Sheet
Ctrl+Shift+PgUp
Select Entire Column
Ctrl+Spacebar
Select Entire Row
Shift+Spacebar
Alt+ shortcuts
Go To Page Layout Tab
Alt+P
For Movement in Page Layout Tab
Alt+P
(use letters as displayed in tab to navigate)
Go To Data Tab
Alt+A
For Movement in Data Tab
Alt+A
(use letters as displayed in tab to navigate)
Go To View Tab
Alt+W
Go To Insert Tab
Alt+N
For Movement in Insert Tab
Alt+N
(use letters as displayed in tab to navigate)
Go to Formula Tab
Alt+M
For Movement in Formula Tab
Alt+M
(use letters as displayed in tab to navigate)
Move to Home tab ribbon
Alt+H
(use letters as displayed in tab to navigate)
Add Borders
Alt+H, B
Select Fill color
Alt+H, H
Align Cell contents to center
Alt+H, A, C
Delete Columns
Alt+H, D, C
Zoom
Alt+W, Q
Enter Line break within a cell
Alt+Enter
Display the style dialog box
Alt + ‘
Keys shortcuts
Remove cell contents
Delete key
Cancel
Escape
Move between commands
(Forward/Backward)
Tab / Shift-Tab


Must read for you :