Top Excel Shortcut For Windows

Published by admin on

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.

Excel World

File Menu Shortcut of excel:

  • 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 : 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
  • Craeat 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

 

(Visited 93 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *