Latest Post

6/recent/ticker-posts

IMPORTANT EXCEL SHORTCUT KEYS


IMPORTANT EXCEL SHORTCUT KEYS

पिछली पोस्ट के माध्यम से आपने एम.एस. वर्ड सॉफ्टवेयर में इस्तेमाल होने वाली महत्वपूर्ण शॉर्टकट की के बारे में जाना था  आप आज की इस पोस्ट में एक्सेल प्रोग्राम में प्रयोग होने वाली शॉर्टकट की के बारे में पढ़ेंगे मुझे आशा है की आपको एम.एस. वर्ड में प्रयोग होने वाली शॉर्टकट की पता चल गई होगी अगर कंप्यूटर से संबंधित कोई भी समस्या है, तो आप हमें टिप्पणी कर सकते हैं। आपकी समस्या का जल्द से जल्द समाधान किया जाएगा।
IMPORTANT EXCEL SHORTCUT KEYS

MS EXCEL SOME IMPORTANT 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 The extreme 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 jump into 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



ALSO LEARN

IMPORTANT SHORTCUT IN PPT.


टिप्पणी पोस्ट करें

0 टिप्पणियां