Home Software 100 Excel shortcut keys

100 Excel shortcut keys

100 Excel shortcut keys

Excel is one of the software, which is part of the Microsoft office package. Excel is widely used all over the world for creating data sheets, visualizing data, analyzing data, and sorting and organizing data. Excel is used for financial analysis in small and big companies. If you want jobs in these small and big companies you must be good at operating excel, and for that, you must know every shortcut key in excel.

Short-cuts make our life easy if you know the keyboard shortcuts of excel you can easily operate excel without touching the mouse often, which saves your time. So today we are going to discuss the 100, most useful excel shortcut keys.

100 Most Useful Excel Shortcut Keys

Sr.n Short-cut key Function
1 Ctrl + A To select all the contents in a workbook.
2 Ctrl + B To turn highlighted cells bold.
3 Ctrl + C To copy cells that are highlighted.
4 Ctrl + D To fill the selected cell with the content of the cell right above.
5 Ctrl + F To search for anything in a workbook.
6 Ctrl + G To jump to a certain area with a single command.
7 Ctrl + H To find and replace cell contents.
8 Ctrl + I To italicize cell contents
9 Ctrl + K To insert a hyperlink in a cell
10 Ctrl + L To open the create table dialog box.
11 Ctrl + N To create a new workbook. Th
12 Ctrl + O To open a saved workbook.
13 Ctrl + P To print a workbook.
14 Ctrl + R Rename the table.
15 Ctrl + S To save a workbook.
16 Ctrl + U To underline highlighted cells.
17 Ctrl + V To paste anything that was copied.
18 Ctrl + W To close your current workbook.
19 Ctrl + Z To undo the last action.
20 Ctrl + 0 To hide a column.
21 Ctrl + 1 To format the cell contents.
22 Ctrl + 5 To put a strikethrough in a cell.
23 Ctrl + 8 To show the outline symbols.
24 Ctrl + 9 To hide a row.
25 Ctrl + Shift + : To enter the current time in a cell.
26 Ctrl + ; To enter the current date in a cell.
27 Ctrl + ` To change the view from displaying cell values to formulas.
28 Ctrl + ‘ To copy the formula from the cell above
29 Ctrl + F5 Refresh data in the current worksheet.
30 Ctrl + Shift + = To insert columns and rows.
31 Ctrl + Shift + ~ Apply the General number format.
32 Ctrl + Shift + @ To apply time formatting.
33 Ctrl + Shift + ! To apply comma formatting.
34 Ctrl + Shift + $ To apply currency formatting.
35 Ctrl + Shift + # To apply date formatting.
36 Ctrl + Shift + % To apply percentage formatting.
37 Ctrl + Shift + & To place borders around the selected cells.
38 Ctrl + Shift + _ To remove a border.
39 Ctrl + – To delete a selected row or column.
40 Ctrl + Spacebar To select an entire column.
41 Ctrl + Shift + Spacebar To select an entire workbook.
42 Ctrl + Home To redirect to cell A1.
43 Ctrl + Shift + Tab To switch to the previous workbook.
44 Ctrl + Shift + F To open the fonts menu under format cells.
45 Ctrl + Shift + + Open the Insert dialog to insert blank cells.
46 Ctrl+F6 Switches between 2 Excel windows.
47 Ctrl+F5 Restores the window size of the selected workbook window.
48 Ctrl + Up arrow To go to the top most cell in a current column.
49 Ctrl + Down arrow To jump to the last cell in a current column.
50 Ctrl + Right arrow To go to the last cell in a selected row.
51 Ctrl + Left arrow To jump back to the first cell in a selected row.
52 Ctrl + End Move to the last cell on a worksheet, to the lowest used row of the rightmost used column.
53 Alt + Page down To move the screen towards the right.
54 Alt + Page Up To move the screen towards the left.
55 Ctrl + F2 To open the print preview window.
56 Ctrl + F1 To expand or collapse the ribbon.
57 Alt To open the access keys.
58 Tab Move to the next cell.
59 Alt + F Open the File page and use the Backstage view.
60 Alt + Down arrow To activate filters for cells.
61 F2 To edit a cell.
62 F3 To paste a cell name if the cells have been named.
63 Shift + F2 Open and edit a cell note
64 Alt + H + H To select a fill color.
65 Alt + H + B To add a border.
66 Ctrl + 9 To hide a row.
67 Ctrl + 0 To hide a column.
68 Esc To cancel an entry.
69 Enter To complete the entry in a cell and move to the next one.
70 Shift + Right arrow To extend the cell selection to the right.
71 Shift + Left arrow To extend the cell selection to the left.
72 Shift + Spacetd>

 

To select the entire row.
73 Page up/ down To move the screen up or down.
74 Alt + H To go to the Home tab in Ribbon.
75 Alt + N To go to the Insert tab in Ribbon.
76 Alt + P To go to the Page Layout tab in Ribbon
77 Alt + M Go to the Formulas tab in Ribbon.
78 Alt + A To go to the Data tab in Ribbon.
79 Alt + R To go to the Review tab in Ribbon.
80 Alt + W To go to the View tab in Ribbon.
81 Ctrl+Esc Close a dialog or cancel a process, such as a paste operation.
82 Alt + Q To quickly jump to search.
83 Alt + Enter To start a new line in a current cell.
84 Shift + F3 To open the Insert function dialog box.
85 F9 To calculate workbooks.
86 Shift + F9 To calculate an active workbook.
87 Ctrl + Alt + F9 Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
88 Ctrl + Esc Close a dialog or cancel a process, such as a paste operation.
89 Ctrl + Shift + F2 Insert a threaded comment
90 Ctrl + Alt + = To zoom in inside a workbook
91 Ctrl + Alt + – To zoom out inside a workbook.
92 F7 Check spelling in the active worksheet or selected range.
93 Ctrl+Q Display the Quick Analysis options for selected cells that contain data.
94 Ctrl+Shift+Home Extend the selection of cells to the beginning of the worksheet.
95 Ctrl+Shift+G Open the Workbook Statistics dialog.
96 Ctrl+Shift+^ Apply the Scientific number format with two decimal places.
97 F11 Create a chart of the data in the current range in a separate Chart sheet.
98 Alt + F11 Open the Microsoft Visual Basic For Applications Editor.
99 F1 To open Microsoft Excel help.
100 Ctrl + F4 To close Microsoft Excel.

As you can see we have shortcut keys for almost every useful command in excel this shortcut key helps us to operate the computer without a mouse by using just a keyboard. Using a keyboard enables us to do the task quickly and save time. If you memorize the above shortcut keys then operating excel can be fun for you.

FAQ About Excel shortcut keys

Q. What is the shortcut key to creating a new workbook in excel?

Ans: Ctrl+N.

Q. What is the shortcut key to close Microsoft Excel?

Ans: Ctrl+F4.

Q. What is the shortcut key to open the saved workbook?

Ans: Ctrl+O.

Q. What is the shortcut key to save the workbook?

Ans: Ctrl+S.

Q.What is the shortcut key to Print Workbook?

Ans: Ctrl+P.