Excel Shortcuts

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 4

S.No.

Excel Shortcuts Functionality Familiarity


1 Ctrl + N To create a new workbook High
2 Ctrl + O To open a saved workbook
3 Ctrl + S To save a workbook
4 Ctrl + A To select all the contents in a workbook High
5 Ctrl + B To turn highlighted cells bold
6 Ctrl + C To copy cells that are highlighted
7 Ctrl + D To fill the selected cell with the content of the cell right above Low
8 Ctrl + F To search for anything in a workbook
9 Ctrl + G To jump to a certain area with a single command
10 Ctrl + H To find and replace cell contents
11 Ctrl + I To italicise cell contents
12 Ctrl + K To insert a hyperlink in a cell Low
13 Ctrl + L To open the create table dialog box
14 Ctrl + P To print a workbook
15 Ctrl + R To fill the selected cell with the content of the cell on the left
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 + 1 To format the cell contents
21 Ctrl + 5 To put a strikethrough in a cell
22 Ctrl + 8 To show the outline symbols
23 Ctrl + 9 To hide a row
24 Ctrl + 0 To hide a column
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 + - To delete columns or rows Low
30 Ctrl + Shift + = To insert columns and rows Low
31 Ctrl + Shift + ~ To switch between displaying Excel formulas or their values in cell
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 + O To select the cells containing comments
46 Ctrl + Drag To drag and copy a cell or to a duplicate worksheet
47 Ctrl + Shift + Drag To drag and insert copy
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 To go to the last cell in a workbook
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 + T To open the options
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 To add or edit a cell comment
64 Alt + H + H To select a fill colour
65 Alt + H + B To add a border
66 Ctrl + 9 To hide the selected rows
67 Ctrl + 0 To hide the selected columns
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 + Space 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 To 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 Alt + Y To open the Help tab in Ribbon
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 To force calculate all workbooks
88 Ctrl + F3 To open the name manager
89 Ctrl + Shift + F3 To create names from values in rows and columns
90 Ctrl + Alt + + To zoom in inside a workbook
91 Ctrl + Alt + To zoom out inside a workbook
92 Alt + 1 To turn on Autosave
93 Alt + 2 To save a workbook
94 Alt + F + E To export your workbook
95 Alt + F + Z To share your workbook
96 Alt + F + C To close and save your workbook
97 Alt or F11 To turn key tips on or off
98 Alt + Y + W To know what's new in Microsoft Excel
99 F1 To open Microsoft Excel help
100 Ctrl + F4 To close Microsoft Excel
Usage Relevance
High High

Medium Medium

Low Low

High
High

You might also like