MS Excel Shortcuts Keys List | Microsoft Excel Shortcuts Keys

Microsoft Excel Shortcuts Keys list. If you use Microsoft Excel regularly, you know that constantly reaching for the mouse to click on various menu items can be quite daunting. That’s why MS Excel Shortcuts Keys come in handy here. By remembering those, you can save a lot of your time and effort. Here is the Microsoft Excel Shortcuts Keys list.

यदि आप नियमित रूप से Microsoft Excel का उपयोग करते हैं, तो आप जानते हैं कि विभिन्न मेनू आइटम पर क्लिक करने के लिए लगातार माउस तक पहुंचना काफी कठिन हो सकता है। इसलिए यहाँ पर  MS Excel Shortcuts Keys काम आती हैं। जिनको याद करके, आप अपना काफी समय और मेहनत बचा सकते हैं। यहाँ पर Microsoft Excel Shortcuts Keys list दिया गया है।

Microsoft Excel all Shortcuts Keys (MS Excel Shortcuts Keys List)

Microsoft Excel all Shortcuts Keys (MS Excel Shortcuts Keys List)
Microsoft Excel all Shortcuts Keys (MS Excel Shortcuts Keys Chart)

ESSENTIAL Excel Shortcuts Keys

Performed ActionShortcut Keys
Undo the last actionCtrl + Z
Redo the last actionCtrl + Y
repeat the last actionF4
Copy to clipboardCtrl + C
Cut to clipboardCtrl + X
Paste from clipboardCtrl + V
Display Paste Special menuCtrl + Alt + V
Find in pageCtrl + F
ReplaceCtrl + H
Find previous matchCtrl + Shift + F4
Find next matchShift + F4
Open WorkbookCtrl + O
Save workbookCtrl + S
Close ExcelAlt + F4

SELECTING SPACIAL CELLS Excel Shortcuts Keys

Display the Go to dialog boxCtrl + G
Select cells with commentsCtrl + Shift + O
Select all visible cellsAlt + ;
Select direct precedentsCtrl + [
Select direct dependentsCtrl + ]
Select all precedentsCtrl + Shift + {
Select all dependentsCtrl + Shift + }

NAVIGATING MS Excel Shortcuts Keys

Move one cell Right →
Move one cell Left ←
Move one cell Up ↑
Move one cell Down ↓
Move to right edge of dataCtrl + →
Move to left edge of dataCtrl + ←
Move to top edge of dataCtrl + ↑
Move to bottom edge of dataCtrl + ↓
Move to beginning of rowHome
Move one screen rightAlt + Page Down
Move one screen leftAlt + Page Up
Move one screen upPage Up
Move one screen downPage Down
Move to first cell in worksheetCtrl + Home
Move to last used cell in worksheetCtrl + End
Display Go To dialog boxCtrl + G

SELECTING THINGS Excel Shortcuts Keys

Select current rowShift + Space
Select current ColumnCtrl + Space
Select current data rangeCtrl + A
Select all cells in worksheetCtrl + A

FORMATTING Excel Shortcuts Keys

Apply / remove bold formattingCtrl + B
Apply / remove underline formattingCtrl + U
Apply / remove italic formattingCtrl + I
Align to CentreAlt + H + A + C
Align to LeftAlt + H + A + L
Align to RightAlt + H + A + R
Indent textAlt + H + 6
Remove indentAlt + H + 5
Increase font size one incrementAlt + H + F + G
Decrease font size one incrementAlt + H + F + K
Display format cells dialog boxCtrl + Shift + F
Display style cells dialog boxAlt + ’

NUMBER FORMATING Excel Shortcuts Keys

Apply number formattingCtrl + Shift + 1
Apply Time formattingCtrl + Shift + @
Apply Date formattingCtrl + Shift + #
Apply Currency formattingCtrl + Shift + $
Apply Percentage formattingCtrl + Shift + %
Apply Scientific formattingCtrl + Shift + ^
Apply Number formattingCtrl + Shift + !

WORKSHEETS Excel Shortcuts Keys

Insert new worksheetShift + F11
Go to next worksheetCtrl + Page Down
Go to Previous worksheetCtrl + Page Up

ACTIVE CELL COMMEANDS Excel Shortcuts Keys

Insert cellsCtrl + Shift + +
Delerte cellsCtrl + –
Move active cell down in selectionEnter
Move active cell up in selectionShift + Enter
Move active cell reght in selectionTab
Move active cell left in selectionShift + Tab
Show the active cellCtrl + Backspace
Deselect all except active cellShift + Backspace

ROWS AND COLUMNS Excel Shortcuts Keys

Insert rows (row selected)Ctrl + Shift + +
Insert columns (Columns row selected)Ctrl + Shift + +
Delete Selectecd rowsCtrl + –
Delete Selectecd columnsCtrl + –
Hide Selectecd columnsCtrl + 0
Hide Selectecd rowCtrl + 9
Unhide Selectecd columnsCtrl + Shift + 0
Unhide Selectecd rowCtrl + Shift + 9
Group rows or colunnsAlt + Shift + Right
Ungroup rows or colunnsAlt + Shift + Left
Open Group dialog boxAlt + Shift + Right
Open Unroup dialog boxAlt + Shift + Left
Hide or show outline symbolsCtrl + 8

EXTENDING SELECTIONS Excel Shortcuts Keys

Extend right by one cellShift + →
Extend left by one cellShift + ←
Extend up by one cellShift + ↑
Extend down by one cellShift + ↓
Extend to right edge of dataCtrl + Shift + →
Extend to left edge of dataCtrl + Shift + ←
Extend to top edge of dataCtrl + Shift + ↑
Extend to bottom edge of dataCtrl + Shift + ↓
Extend right by one screenAlt + Shift + Page Down
Extend left by one screenAlt + Shift + Page Up
Extend up by one screenShift + Page Up
Extend down by one screenShift + Page Down

CELL BORDERS Excel Shortcuts Keys

Add border on all edgesCtrl + Shift + &
Remove all bordersCtrl + Shift + –
Add / remove right borderAlt + R
Add / remove left borderAlt + L
Add / remove top borderAlt + T
Add / remove bottom borderAlt + B
Add / remove diagonal up borderAlt + U
Add / remove diagonal down borderAlt + D
Add / remove horizontal interior borderAlt + H
Add / remove vertical interior borderAlt + V

ENTERING DATA Microsoft Excel Shortcuts Keys

Edit the active cellF2
Cancel data entryEsc
Delete Contents of selected cellsDelete
Insert new line into cellAlt + Enter
Complete entry & move one cell downEnter
Complete entry & move one cell upShift + Enter
Complete entry & move one cell rightTab
Complete entry & move one cell leftShift + Tab
Complete entry & stay in current cellCtrl + Enter
Enter data in all selected cellsCtrl + Enter
Insert / edit commentShift + F2
Copy contents from cell aboveCtrl + D
Copy contents from cell to the leftCtrl + R
Copy formula from cell aboveCtrl + +
Copy value from cell aboveCtrl + Shift + –
Add hyperlinkCtrl + K
Insert current dataCtrl + ;
Insert current timeCtrl + :
Display autocomplete listAlt + Down
Flash fill down to end of data regionCtrl + E

WORKBOOKS Excel Shortcuts Keys

Go to nest workbookCtrl + Tab
Go to previous workbookCtrl + Shift + Tab
Create new workbookCtrl + N
Open workbook (file menu)Ctrl + O
Open workbook (classic)Ctrl + F12

इस पोस्ट में आपने सीखा MS Excel Shortcuts Keys List जो आपके लिए बेहद ही महत्वपूर्ण हो सकती है। यदि आप MS Excel पर काम करते हैं तो। इसके साथ ही यदि आप किसी भी Competitive exam की तैयरी कर रहें है तो आपके लिए यह जानकारी हेल्पफुल रहेगी। इसे अपनो दोस्तों के साथ जरूर शेयर करें धन्यवाद!

Read Also…

100 shortcut keys in Computer

Keyboard Hindi typing chart pdf file download

What is use of function keys?

FAQ for Microsoft Excel Shortcuts Keys

What is Ctrl F12 in Excel?

Ctrl + F12 Opens the “File Open Dialog Box”. and
F12 Opens “Save As” dialog box

20 shortcut keys of MS Excel

Undo the last action → Ctrl + Z
Redo the last action → Ctrl + Y
repeat the last action → F4
Copy to clipboard → Ctrl + C
Cut to clipboard → Ctrl + X
Paste from clipboard → Ctrl + V
Display Paste Special menu → Ctrl + Alt + V
Find in page → Ctrl + F
Replace → Ctrl + H
Find previous match → Ctrl + Shift + F4
Find next match → Shift + F4
Open Workbook → Ctrl + O
Save workbook → Ctrl + S
Close Excel → Alt + F4
Move one cell Right  → (Right arrow)
Move one cell Left ← (Left arrow)
Move one cell Up ↑ (Up arrow)
Move one cell Down ↓ (Down arrow)
Move to right edge of data Ctrl + →
Move to left edge of data Ctrl + ←
Move to top edge of data Ctrl + ↑
Move to bottom edge of data Ctrl + ↓

Leave a Comment