By Shivani Garg
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
|
Also read : MS Excel tutorials for you :)
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
|
Also read : MS Excel tutorials for you :)
Related >>
Labels:
MS Excel
Shivani Garg