100+ MS Excel Shortcut Keys

MS Excel Shortcut Key – Hello friends, today in this article we will learn about computer shortcut keys. 100+ MS Excel Shortcut Keys in Hindi. This article has been written in very simple words. Read it completely, you will understand it easily, so let’s start.

MS Excel Shortcut Key

Many types of shortcut keys are used in MS Excel. Which we have explained below:-

Daily Use Excel Shortcut Keys

While working in MS Excel, there are many common tasks that we need to perform on a daily basis. Often, we accomplish these tasks using the mouse, such as selecting text, searching words in a worksheet, closing Excel windows, deleting data from a cell, and much more.

By using the following common Excel shortcuts, you can easily streamline these common tasks, saving your valuable time:-

1. Ctrl + A – Select all data.
2. Ctrl + C – Copy selected text.
3. Ctrl + D – Copy data from the upper cell to the lower cell.
4. Ctrl + F – Find a word or phrase in the worksheet.
5. Ctrl + H – Change text in the worksheet.
6. Ctrl + K – Insert Hyperlink.
7. Ctrl + R – Paste data from left cell to right cell without copy-pasting.
8. Ctrl + U – Underline selected text.
9. Ctrl + V – Paste the copied text at another location.
10. Ctrl + X – Cut selected text.
11. Ctrl + Y – Redo an action.
12. Ctrl + Z – Undo an action.
13. Ctrl + F4 – Close the Excel window.
14. Delete – Delete selected cells or data within the cell range.
15. Ctrl + F1 – Show/Hide the Excel ribbon.
16. Ctrl + F9 – Minimize the Excel window.
17. Ctrl + ; – Enter the current date.
18. Ctrl + Shift + ; – Enter the current time.
19. Shift + F10 – Open the right-click menu.
20. Alt + Tab – Open system menu.
21. Alt + F1 – Create a chart for the selected data.
22. Alt + F8 – Open the Macro dialog box to create, run, edit, or delete macros.
23. Alt + F11 – Open Visual Basic for Applications editor.
24. Ctrl + “ – Copy a value from the above cell.
25. Shift + F2 – Insert and edit comments in a cell.

These shortcuts will help you manage your Excel workbooks efficiently, making your tasks easier and more convenient.

Shortcut Keys for Cell Formatting

1. Ctrl + 1 – Open the Format Cells dialog box.
2. Alt + H, J – Apply Cell Styles.
3. Alt + H + B, A – Add border to the cell.
4. Ctrl + Shift + (-) – Delete cell border.
5. Alt + H + B, T – Apply Outline Border to the cell.
6. Alt + H + A, C – Align data to the center of the cell.
7. Ctrl + Shift + % – Convert numbers to percentage format.
8. Ctrl + Shift + $ – Display numbers in Currency Format.
9. Ctrl + Shift + (~) – Display numbers in normal number format.
10. Ctrl + Shift + # – Apply date format.
11. Ctrl + Shift + @ – Apply time format.
12. Alt + ‘ – Insert carriage return in the cell.

Shortcut Keys to Navigate in Excel

1. Up Arrow – Go to the upper cell.
2. Down Arrow – Go to the cell below.
3. Left Arrow – Shift to the leftmost cell.
4. Right Arrow – Go to the cell on the right.
5. Ctrl + Down Arrow – Go to the last row.
6. Ctrl + Up Arrow – Go to the first row.
7. Ctrl + Left Arrow – Go directly to the last column.
8. Ctrl + Right Arrow – Go to the first column.
9. Ctrl + Tab – Switch seamlessly between open workbooks.
10. Ctrl + PageDown – Go to the next sheet in workbooks.
11. Ctrl + PageUp – Go to previous sheet.
12. Alt + H – Go to Home Tab.
13. Alt + N – Access the Insert Tab.
14. Alt + P – Explore the Page Layout tab.
15. Alt + M – Go to Formula Tab.
16. Alt + A – Navigate to Data Tab.
17. Alt + R – Go to Review Tab.
18. Alt + W – Explore the View tab.

Shortcut Keys related to Excel Formulas

1. Ctrl + Shift + U – Easily extend and collapse the Formula Bar.
2. Shift + F3 – Open the Insert Function Dialog Box, which lets you search for and insert functions into a cell.
3. Ctrl + ` – Display the formula present in the selected cell.
4. Ctrl + ‘ – Quickly copy the formula from the above cell.
5. Alt + = – Use the AutoSum Function in a cell for quick calculations.

Excel Shortcut Keys related to Table

1. Ctrl + T – To create a new table or convert existing data into a table.
2. Shift + Space – Select an entire row in the table.
3. Ctrl + Space – Select an entire column in the table.
4. Ctrl + Shift + End – Select the entire table. You can also use Ctrl + A shortcut key.
5. Ctrl + Shift + (+) – To insert rows in the table. Remember to place the cursor on the rows above where you want to insert new rows.
6. Ctrl + Shift + (+) – Using the same shortcut key that you used for Rows insertion, you can also insert Columns in the Table. Select two or more cells in the range where you want to insert a new column.
7. Ctrl + (-) – Delete a row from the table.
8. Ctrl + (-) – Using this shortcut key you can also delete a column. Select two or more cells in the column you want to delete and then press this key combination.
9. Ctrl + Shift + L – Toggle filters on/off in an Excel Table or Data Range.
10. Alt + H + O, I – Use AutoFit to adjust the width of a column.
11. Alt + H + O, A – Use AutoFit to adjust row height.
12. Ctrl + Shift + T – Add or delete the total number of rows below the last row in the table.
13. Ctrl + J, A – Rename Table.

Excel Function Shortcut Keys (F1 – F12)

F1 – Press F1 for Help in Excel.
F2 – Edit the contents of selected cells.
F3 – Open the Paste Name window.
F4 – Use F4 to repeat the last action or change relative cell references to absolute references.
F5 – Access the Go To Dialog Box.
F6 – Switch between Worksheet, Ribbon, Task Pane and Zoom Controls.
F7 – Display Spelling Dialog Box.
F8 – Toggle Extend Mode on/off.
F9 – Evaluate formulas in cells.
F10 – Show Ribbon Shortcuts.
F11 – Create a chart sheet for the selected data.
F12 – Open the Save As dialog box to save your work book with a new name.

Conclusion

Friends, we hope that from this article you would have come to know about computer shortcut keys in Hindi. MS Excel Shortcut Key If you have any question related to this article, you can ask by commenting below. Share it with your friends.

Friends, more such important articles are available on this website – tech.somumax.com. You can read the article by visiting this website.