MS EXCEL SHORTCUT KEYS
MS Excel को Microsoft द्वारा विकसित किया गया है, MS Excel Microsoft Office का एक भाग है| M.S. Excel, का पूरा नाम ‘Microsoft Excel’ है तथा इसे ‘Excel’ के नाम से भी जानते है, यह एक Spread Sheet Program है, जो डाटा को Tabular format में open, create, edit, formatting, calculate, share एवं print आदि करने का कार्य करता है.
DESCRIPTION
|
SHORTCUT KEY
| |
Set Monitor Cell Three
|
Alt + Ctrl + Shift + 3
| |
Set Monitor Cell Four
|
Alt + Ctrl + Shift + 4
| |
Set Monitor Cell Five
|
Alt + Ctrl + Shift + 5
| |
Set Monitor Cell Six
|
Alt + Ctrl + Shift + 6
| |
Set Monitor Cell Seven
|
Alt + Ctrl + Shift + 7
| |
Set Monitor Cell Eight
|
Alt + Ctrl + Shift + 8
| |
Set Monitor Cell Nine
|
Alt + Ctrl + Shift + 9
| |
Set Monitor Cell 10
|
Alt + Ctrl + Shift + 0
| |
Read Monitor Cell One
|
Alt + Shift + 1
| |
Read Monitor Cell
|
Two Alt + Shift + 2
| |
Read Monitor Cell Three
|
Alt + Shift + 3
| |
Read Monitor Cell Four
|
Alt + Shift + 4
| |
Read Monitor Cell Five
|
Alt + Shift + 5
| |
Read Monitor Cell Six
|
Alt + Shift + 6
| |
Read Monitor Cell Seven
|
Alt + Shift + 7
| |
Read Monitor Cell Eight
|
Alt + Shift + 8
| |
Read Monitor Cell Nine
|
Alt + Shift + 9
| |
Read Monitor Cell Ten
|
Alt + Shift + 0
| |
List Visible Cells With Data
|
Ctrl + Shift + D
| |
Lists Data In Current Column
|
Ctrl + Shift + C
| |
List Data In Current Row
|
Ctrl + Shift + R
| |
Select Hyperlink
|
Ctrl + Shift + H
| |
Move To Worksheet List box
|
Ctrl + Shift + S
| |
Move To Monitor Cell
|
Ctrl + Shift + M
| |
Select Worksheet Objects
|
Ctrl + Shift + O
| |
List Cells At Page Breaks
|
Ctrl + Shift + B
| |
Options List box
|
Insert + V
| |
Inserting Text Automatically
Description
|
Shortcut Key
|
Autosum a range of cells
|
Alt + Equals Sign
|
Insert the date
|
Ctrl + ; (semi-colon)
|
Insert the time
|
Ctrl + Shift + ; (semi-colon)
|
Insert columns/rows
|
Ctrl + Shift + + (plus sign)
|
Insert a new worksheet
|
Shift + F11
|
Description
|
Shortcut Key
|
Find text
|
Ctrl + F
|
Replace text dialog
|
Ctrl + H
|
Create a chart automatically on a new sheet
|
F11
|
Edit a cell comment
|
Shift + F2
|
Main Jaws Keystrokes In Excel
|
Main Jaws Keystrokes In Excel
|
Say Version of Excel
|
Ctrl + Shift + V
|
Move to Next Sheet
|
Ctrl + Page Down
|
Move to Prior Sheet
|
Ctrl + Page Up
|
Go to a cell command
|
Ctrl + G
|
Collapse Selection To Active Cell
|
Shift + Backspace
|
Say Active Cell Coordinates
|
Insert + C
|
AutoSum
|
Alt + Equals
|
Formula Mode
|
Equals Sign
|
Insert Date In Current Cell
(semicolon)
|
Ctrl + ;
|
Insert Time In Current Cell
(semicolon)
|
Ctrl + Shift + ;
|
Current Column First Cell From Top
|
Alt + 1
|
Current Column Second Cell From Top
|
Alt + 2
|
Current Column Third Cell From Top
|
Alt + 3
|
Current Column Fourth Cell From Top
|
Alt + 4
|
Data Region Left
|
Ctrl + Left Arrow
|
Data Region Right
|
Ctrl + Right Arrow
|
Data Region Down
|
Ctrl + Down Arrow
|
Data Region Up
|
Ctrl + Up Arrow
|
Select Whole Data Region
|
Ctrl + Shift + 8
|
Say Formula
|
Ctrl + F2
|
Spell Check
|
F7
|
Report Gridline Status
|
Alt + Shift + g
|
Read Row Total
|
Insert + Delete
|
Read Column Total
|
Insert + Enter
|
Say Column Title
|
Alt + Shift + C
|
Say Row Title
|
Alt + Shift + R
|
Say Visible Range Coordinates
|
Alt + Shift + V
|
Cycle Through Controls in Dialog Box Tab
| |
Tab Backwards
|
Shift + Tab
|
List Cells With Comments
(apostrophe)
|
Ctrl + Shift + '
|
Row Second Cell From Left
|
Alt + Ctrl + 2
|
Row First Cell From Left
|
Alt + Ctrl + 1
|
Row Third Cell From Left
|
Alt + Ctrl + 3
|
Row Fourth Cell From Left
|
Alt + Ctrl + 4
|
Describe Cell Border
|
Alt + Shift + B
|
Read Cell Comment
(apostrophe)
|
Alt + Shift + '
|
Auto Filter
|
Ctrl + Shift + A
|
Read Cell Hyperlink
|
Alt + Shift + H
|
Close Office Assistant
|
Ctrl + Insert + F4
|
Set Monitor Cell One
|
Alt + Ctrl + Shift + 1
|
Set Monitor Cell Two
|
Alt + Ctrl + Shift + 2
|
fb page :- CAREER MITRA
FOLLOW the Blog – Pratiyogita sutra
"अगर आपको यह पोस्ट पसंद आयी हो तो इसे LIKE और SHARE, COMMENT जरूर करें" और सबसे पहले जानकारी पाने के लिए BLOG को SUBSCRIBE करे "
MS EXCEL SHORTCUT KEYS
No comments:
Post a Comment