Excel is one of the most usable to Office Product which is used worldwide.
Here going to share Excel shortcut to use in day to day to work.
File Menu Shortcut of excel:
Table of Contents
- Create New Workbook – CTRL + N
- Open New Workbook – Ctrl + O
- Print File – Ctrl + P
- Open Print Preview – Ctrl + F2
- Save Workbook – Ctrl + S
- Close Current Workbook – Ctrl + F4
- Close Excel – Alt + F4
Table & Filter Shortcut :
Insert Table – Ctrl + T
- Start Filter or Remove Filter : Ctrl + Alt + L
- Active Filter : Atl + ↓
- Select Table Row : Shift + Space
- Select Table Column : Ctrl + Space
- Select Table : Ctrl + A
- Clear Slicer Filter : Alt + C
- Add outline Border : Ctrl + Shift + &
- Remove Borders :Ctrl + Shift + _
Cell:
- Edit Cell : F2
- Insert Comment : Shift + F2
- Cancel Entry : Esc
- Select One Character : Shift + Arrow (←,→)
- Move One word right : Ctrl + →
- Move one word Left : Ctrl + ←
- Select End of the Cell : Shift + End
- Delete Line : Ctrl + Delete
- Delete character to the Left of cursor : Backspace
- Delete character to the Right of cursor : Delete
- Start New Line in Same Cell : Atl + Enter
Insert Data in Cell of Excel :
- Move Down to cell : Enter
- Move Up to Cell : Shift + Enter
- Move to Right side Cell : Tab
- Move to Left Side Cell : Shift + Tab
- Complete Entry and Stay in Same Cell : Ctrl + enter
- Insert Current Date: Ctrl + ;
- Insert Current Time : Ctrl + Shift + ;
- Fill Down Same Cell Value : Ctrl + D
- Fill Right From Left Cell : Ctrl + R
- Add Hyperlink : Ctrl + K
- Flash Fill : Ctrl + E
Others Shortcuts for Excel:
- Open Spelling Dialog box : F7
- Paste Special : Ctrl + Alt + V
- Open macro Dialog Box : Alt + F8
- Expand or Open Ribbon : Ctrl + F1
- Active Access Key in Ribbon : Alt
- Open Excel Options : Alt + F + T
- Undo Last Action : Ctrl + Z
- Redo Last Action : Ctrl + R
- Repeat Last Action : F4
- Display Right Match : Shift + F4
- Create Embedded chart : Alt + F1
- Drag to other Worksheet :Alt + Drag
- Display Go to Option : Ctrl + G
You May Like to Refer : How to use Rept Function in Excel
You May Like to Refer : How to Add Drop down list in Excel
You May Like to Live Radio on Your Phone :
Listen Live Radio