MS Excel Shortcut Keys in Hindi | All Excel Shortcuts
SHARE
आज के लेख में आप MS Excel Shortcut Keys in Hindi के बारे जानेंगे। बदलते समय के साथ सब डिजिटल हो गया है, जिस वजह से कंप्यूटर का इस्तेमाल ज्यादा हो रहा है। सभी काम कंप्यूटर के जरिये जहि किये जा रहे है, यहाँ तक की banking से लेकर education में भी इसका इस्तेमाल हो रहा है।
ऑफिस वर्क में Excel का इस्तेमाल सबसे ज्यादा किया जाता है। स्कूल के प्रोजेक्ट बनाने से लेकर पैसो का हिसाब किताब सिर्फ एक software के जरिये किया जा सकता है। MS Excel के ज्यादातर कामो को Shortcut Keys के जरिये कुछ ही सेकण्ड्स में कर सकते है।
500 MS Excel Shortcut Keys in Hindi
MS Excel में कई प्रकार के Shortcut Keys का उपयोग होता है। जिसका इस्तेमाल हम Excel पर काम करते समय कर सकते है और अपना समय बचा सकते है।
Function Keys In Excel
Key
Function
F1
Shows Excel Help
F2
Enters edit mode for the active cell
F3
Displays the Paste Name dialog box if there is a defined name
F4
Repeats the last action. Also, writing a formula allows you to switch between relative, absolute, and mixed references.
F5
Displays the Go To dialog box
F6
Allows you to move between panels in a divided book
F7
Displays the Spelling dialog box
F8
Activates Expand Selection mode, which allows you to enlarge the selected range using the arrow keys
F9
Calculates the result of formulas for all sheets of open workbooks
F10
Activates the menu bar
F11
Creates a chart sheet with the selected cell range
F12
Displays the Save As dialog box
Single Key Shortcuts
Key
Function
Alt
Activates the menu bar
Page Down
Scrolls down one screen within the sheet
Enter
Completes a cell entry and selects the cell located below
Esc
Cancels the entry of a cell. It also closes any displayed dialog
Space
Enables or disables a check box within a dialog box
End
Allows you to use the arrow keys to move to the last cell in the current range
Home
Moves to the beginning of the row
Page Up
Move one screen up within the sheet
Backspace
Deletes the contents of a cell and enters Edit Mode
Delete
Deletes the content of a cell
Tab
Completes a cell entry and selects the cell to the right
Direction keys
Selects the top, bottom, left, or right cell according to the direction key pressed
Basic Keyboard Shortcuts In Excel
Key
Function
Ctrl+A
Select all
Ctrl+B
Applies bold formatting to selected text
Ctrl+C
Copies the selected cells
Ctrl+D
Copies the contents and format of the topmost cell of a selected range in the below cells
Ctrl+E
Invokes Flash Fill to recognize patterns in adjacent columns and fill the current column
Ctrl+G
Opens the Go To dialogue box so that you can work on a specific reference (cell)
Ctrl+I
Italicize the selected cell/s
Ctrl+J
Removes line breaks in a cell
Ctrl+K
Hyperlinks in a cell
Ctrl+L
Opens the Create Table dialog box
Ctrl+O
Opens an existing workbook
Ctrl+N
Opens a new workbook
Ctrl+P
Displays the Print dialog box
Ctrl+R
Fills the row cell(s) to the right with the contents of the selected cell/Aligns a cell with the contents of the left cell
Ctrl+S
Saves the workbook
Ctrl+T
Displays the Create Table dialog box
Ctrl+U
Underlines the selected text
Ctrl+V
Pastes the contents of the clipboard
Ctrl+X
Cuts the selected cells
Ctrl+Y
Redoes the last undone action
Ctrl+Z
Undoes the last action
Ctrl+1
Opens the Format Cells dialog box
Ctrl+2
Applies bold formatting to selected text
Ctrl+3
Applies italic formatting to selected text
Ctrl+4
Underlines the selected text
Ctrl+5
Applies the strikethrough effect to the text
Ctrl+6
Hides or shows the objects on the sheet
Ctrl+8
Shows the outline symbols on the sheet
Ctrl+9
Hides the selected row
Ctrl+0
Hides the selected column
Keyboard Shortcuts With Ctrl And Function Keys
Key
Function
Ctrl+F1
Displays/hides the ribbon
Ctrl+F2
Displays the print preview area on the Print tab
Ctrl+F3
Opens Name Manager dialog box
Ctrl+F4
Closes the active workbook
Ctrl+F5
Restores the window size of the selected workbook window
Ctrl+F6
Switches to the next workbook window if more than one workbook windows is open
Ctrl+F7
Allows you to move the workbook window when the window is not maximized
Ctrl+F8
Allows you to resize the workbook window when the window is not maximized
Ctrl+F9
Minimizes the current workbook window to an icon
Ctrl+F10
Maximizes the window of a minimized workbook
Ctrl+F11
Inserts a macros sheet into the current workbook
Ctrl+F12
Displays the Open dialog box
Keyboard Shortcuts With Shift And Function Keys
Key
Function
Shift+F2
Insert a note. Open and edit a cell note
Shift+F3
Displays the Insert Function dialog box. Editing a formula displays the Function Arguments dialogue box.
Shift+F4
Executes the “Find Next” command according to the previously indicated search terms
Shift+F5
Displays the Find dialog box
Shift+F6
Switches focus between the sheet, the Ribbon, the status bar, and the task pane (if present)
Shift+F7
Displays the Reference task pane
Shift+F8
It lets you add another range of cells to the selection
Shift+F9
Calculates the formulas of the current sheet
Shift+F10
Shows the right-click menu for selection
Shift+F11
Inserts a new sheet
Shift+F12
Displays the Save As dialog box
Keyboard Shortcuts With The Ctrl+Shift Keys
Key
Function
Ctrl+Shift+F3
Displays the Create Names From Selection dialog box
Ctrl+Shift+F6
Switch to the previous workbook window
Ctrl+Shift+F10
Activates the menu bar
Ctrl+Shift+F12
Displays the Print dialog box
Ctrl+Shift+F
Displays the Font tab of the Format Cells dialog box
Ctrl+Shift+L
Turns filters on or off in a range (Toggle)
Ctrl+Shift+O
Select cells with comments
Ctrl+Shift+U
Expands the formula bar
Ctrl+Shift+Enter
Enters a formula as an array formula
Ctrl+Shift+Home
Extends the selection to the beginning of the sheet
Ctrl+Shift+End
Extends the selection to the last used cell on the sheet
Ctrl+Shift+PageDown
Adds the next sheet to the selection of sheets
Ctrl+Shift+Page Up
Adds the previous sheet to the sheet selection
Ctrl+Shift+Direction key
Extends the selection to the last non-empty cell in the same direction as the key pressed
Ctrl+Shift+Space
Select the current cell range or the entire sheet
Ctrl+Shift+(
Show hidden rows within the selected range
Ctrl+Shift+)
Show hidden columns within the selected range
Ctrl+Shift+!
Applies the Number in two decimals format
Ctrl+Shift+#
Applies the Currency format with two decimal places
Ctrl+Shift+$
Applies the Percent format without decimals
Ctrl+Shift+%
Applies the Scientific notation format
Ctrl+Shift+/
Applies the Time format
Ctrl+Shift+:
Applies a border to the cell
Ctrl+Shift+&
Removes cell borders
Ctrl+Shift+” “
Copies the cell’s content above
Keyboard Shortcuts To Navigate In Excel
Key
Function
Alt+Page Down
Moves the worksheet one page to the right
Alt+PageUp
Moves the worksheet one page to the left
Ctrl+Page Down
Move down in the given range
Ctrl+Page Up
Move up in the given range
Ctrl+Home
Move to cell A1
Ctrl+End
Move to the last used cell in the current range
Ctrl+Backspace
Gets you back to your active cell
Ctrl+Tab
Switches between the open workbooks
Ctrl+Direction key
Move to the end of the current row or column according to the direction key pressed.
Keyboard Shortcuts To Enter Data And Formulas
Keys
Function
Alt+=
Inserts an AutoSum of the adjacent cells
Alt+Down
Displays the options of a data validation list
Alt+Enter
Inserts a line break within a cell
Ctrl+, (comma)
Insert the current date
Ctrl+:
Inserts the current time
Ctrl+” (double quotes)
Copies the value of the cell above
Ctrl+’ (single quote)
Copies the formula from the cell above
Ctrl+Enter
Fills the selected cell range with the current input
Ctrl+Delete
Deletes all text up to the end of the line
Ctrl+Alt+K
Insert a hyperlink
Shift+Enter
Completes cell entry and selects the top cell
Shift+Tab
Completes the cell entry and selects the cell to the left
Other MS Excel Shortcut Keys
Keys
Function
Alt+Space
Opens the Excel window control menu
Alt+’ (single quote)
Displays the Style dialog box
Alt+Ctrl+Left
Moves left between non-adjacent cells in a selected range
Alt+Ctrl+Right
Moves right between non-adjacent cells in a selected range
Ctrl+-
Displays the Delete Cells dialog box
Ctrl++
Displays the Insert Cells dialog box
Ctrl+Alt+V
Displays the Paste Special dialog box
MS Excel का इस्तेमाल सभी तरह के कामो में किया जाता है, आज के समय में इसके बिना जीना संभव नहीं है। जुआदतर लोगो को अपने ऑफिस में इसपर काम करना होता है, लेकिन इसके बारे में ज्यादा जानकारी नहीं होने की वजह से लोग इस पर अच्छे से काम नहीं कर पाते। लेकिन MS Excel Shortcut Keys का इस्तेमाल करके आसानी से इस सॉफ्टवेयर के सभी कामो को कर सकते है।
निष्कर्ष
आज के लेख में Microsoft Excel Shortcut Keys के बारे में विस्तार से बताया, आशा करते है की इस से आपको जरूर सिखने को मिला होगा। इस लेख को अपने दोस्तों के साथ सोशल मीडिया पर जरूर साँझा करे, जिस से उनको भी इसके बारे में पता चल सके।
यदि आप हमारी वेबसाइट के नवीनतम अपडेट प्राप्त करना चाहते हैं, तो Minidea को Subscribe जरूर करे। साथ ही हमें Facebook पर जरूर Follow करे।