MS Excel Shortcut Keys in Hindi | All Excel Shortcuts 2024

आज के लेख में आप 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 करे।