IMPORTANT EXCEL SHORTCUT KEYS
पिछली पोस्ट के माध्यम से आपने एम.एस. वर्ड सॉफ्टवेयर में इस्तेमाल होने वाली महत्वपूर्ण शॉर्टकट की के बारे में जाना था आप आज की इस पोस्ट में एक्सेल प्रोग्राम में प्रयोग होने वाली शॉर्टकट की के बारे में पढ़ेंगे मुझे
आशा है की आपको एम.एस. वर्ड में प्रयोग होने वाली शॉर्टकट की पता चल गई होगी अगर कंप्यूटर से संबंधित कोई भी समस्या है, तो आप हमें टिप्पणी कर सकते हैं। आपकी समस्या का जल्द से जल्द समाधान किया जाएगा।
आशा है की आपको एम.एस. वर्ड में प्रयोग होने वाली शॉर्टकट की पता चल गई होगी अगर कंप्यूटर से संबंधित कोई भी समस्या है, तो आप हमें टिप्पणी कर सकते हैं। आपकी समस्या का जल्द से जल्द समाधान किया जाएगा।
MS EXCEL SOME IMPORTANT
SHORTCUT KEYS
SHORTCUT KEYS
|
F1
|
Display Help Box.
|
|
F2
|
correct the String / Text of Selected Cell
|
|
F5
|
Use for GO TO Cell Option
|
|
F7
|
For Spell check in the entire worksheet
|
|
F8
|
Select the cells from to range
|
|
F10
|
go to the Menu Bar
|
|
F11
|
Merge the current sheet in to CHART
|
|
F12
|
Save the copy of Current Workbook
|
|
SHIFT + F2
|
Insert comment
|
|
SHIFT + F3
|
Open the Insert Function dialog Box
|
|
SHIFT + F4
|
Used to repeat the Last Action
|
|
SHIFT + F5
|
Used for FIND / REPLACE command
|
|
SHIFT + F8
|
get the Addition of Two Selected Cells
|
|
SHIFT + F10
|
Open the shortcut menu for selected Item
|
|
SHIFT + F11
|
Insert the new worksheet
|
|
SHIFT + F12
|
Save the File
|
|
CTRL + F3
|
Define the Name of Selected cells (Create cell reference)
|
|
CTRL + F4
|
Close the Active Workbook
|
|
CTRL + F5
|
Use to Arrange the Window of Worksheet in Tide Style
|
|
CTRL + F9
|
Minimize the Current Worksheet
|
|
CTRL + F10
|
Maximize the Worksheet
|
|
CTRL + F11
|
Open the MACRO SHEET
|
|
CTRL + F12
|
Save a Copy of active Workbook
|
|
ALT + F1
|
Merge the current sheet in to CHART
|
|
ALT + F2
|
Save a Copy of active Workbook
|
|
ALT + F4
|
Close the Excel or Exit from Excel
|
|
CTRL + ALT + F1
|
Use to Refresh the Monitor
|
|
CTRL + ;
|
Insert Current Date
|
|
CTRL + SHIFT + ;
|
Insert Current Time
|
|
CTRL + 1
|
Shortcut For Opening dialog Box of Format Cell
|
|
CTRL + 2
|
Use to Bold the Selected Text / cell
|
|
CTRL + 3
|
Use to Italic the Selected Text / cell
|
|
CTRL + 4
|
Use to Underline the Selected Text / Cell
|
|
CTRL + 5
|
Use to Strikethrough the Selected Text / Cell
|
|
CTRL + 6
|
Disable /Enable Drawings Tool
|
|
CTRL + 7
|
Hide / Unhide Standard Tools Bar
|
|
CTRL + 8
|
Use to Show the Outline Symbols
|
|
CTRL + 9
|
Hide a Row
|
|
CTRL + 0
|
Hide a Column
|
|
CTRL + –
|
Delete Column / Row / Cell
|
|
CTRL + +
|
Insert Column / Row
|
|
CTRL + Right
Arrow |
Move the insertion point to the next cell containing text /string on right side
|
|
CTRL + Left
Arrow |
Move the insertion point to the previous cell containing text /string on left side
|
|
CTRL + Up
Arrow |
Move the insertion point to the upper cell containing text /string on left side
|
|
CTRL + Down
Arrow |
Move the insertion point to the Lower cell containing text /string on left side
|
|
CTRL +Insert
|
Copy selected cell
|
|
CTRL +Delete
|
Delete Selected Cell
|
|
CTRL +Home
|
Move on The extreme Left Upper Cell in the Active Worksheet
|
|
CTRL +End
|
Move on Theextreme Last Fill Cell in the Active Worksheet
|
|
CTRL + Page Up
|
Move on the previous worksheet in the Active Workbook
|
|
CTRL + Page Down
|
Move on the Next worksheet in the Active Workbook
|
|
CTRL + Spacebar
|
select the Entire Column
|
|
CTRL + Esc
|
Open the Start Menu Bar
|
|
CTRL + TAB
|
Use to Jump From File Menu to Tool Menu
|
|
CTRL +A
|
select the Whole Active Worksheet
|
|
CTRL +B
|
Bold the Selected Cell / Text
|
|
CTRL + C
|
Copy selected cell / Text / Object
|
|
CTRL + D
|
Fill the Same Item in the Exact upper Cell to the selected cell/s
|
|
CTRL + F
|
Find some thing in the active worksheet
|
|
CTRL +G
|
use the Go to Command
|
|
CTRL + H
|
Replace some thing in the Active Worksheet
|
|
CTRL + I
|
convert Selected String into Italic Style
|
|
CTRL +K
|
Insert Hyperlink
|
|
CTRL +L
|
create List
|
|
CTRL + N
|
Open New Workbook
|
|
CTRL + O
|
Open Already Save File
|
|
CTRL + P
|
Print Current Sheet
|
|
CTRL + S
|
Save the Worksheet
|
|
CTRL + U
|
Underline the Selected Text
|
|
CTRL + V
|
Paste the Copied Items .
|
|
CTRL + W
|
Close the Active Workbook
|
|
CTRL + X
|
Cut the Selected Items
|
|
CTRL +Y
|
Use for REDO command
|
|
CTRL +Z
|
Use for UNDO command
|
|
TAB
|
Jump from One Cell to Another on Right Side
|
|
SHIFT + TAB
|
Jump from One Cell to Another on Left Side
|
|
ALT + TAB
|
Switch between the Open Applications / Windows
|
|
Space Bar
|
Clear the Contents of Selected Cell
|
|
Backspace
|
Clear the Contents of Selected Cell
|
|
ALT + Space Bar
|
Display the System Menu of Active Application
|
|
ALT +-
|
Display the System Menu of Active Window in Active Application
|
|
CTRL + SHIFT+ F
|
Directly jumpinto Font Style
|
|
CTRL + SHIFT+ P
|
Directly jump into Font Size
|
|
CTRL + SHIFT + ;
|
Submit the Current Time in the selected Cell
|
|
CTRL + SHIFT + Page up / down
|
Select Two Sheet in One Time
|
|
SHIFT + CTRL + Right
Arrow |
Select the Entire Range in Row from current to Next Fill Cell towards right side
|
|
SHIFT + CTRL + Left
Arrow |
Select the Entire Range in Row from current to Next Fill Cell towards lift side
|
|
SHIFT + CTRL + Up
Arrow |
Select the Entire Range in Column from current to Next Fill Cell towards up
|
|
SHIFT + CTRL + Down
Arrow |
Select the Entire Range in Column from current to Next Fill Cell towards below
|
|
SHIFT + CTRL + 9
|
Unhide the Hidden Column
|
|
SHIFT + CTRL + 0
|
Unhide the Hidden Row
|
