100 Useful Microsoft Excel Shortcuts
Excel Shortcuts. In the journey of learning Microsoft Excel, we learn a lot of functions and keywords. We learn several techniques to handle and manipulate data. It will be really helpful if we learn to use shortcuts. So here I am with 100 shortcuts. These shortcuts are collected for Windows users. Let us begin.
100 Excel Shortcuts
| Keyword | For | |
| 1 | Control + N | Create New Workbook |
| 2 | Control + O | Open a Workbook |
| 3 | Control + S | Save a Workbook |
| 4 | Control + B | Turn the highlighted Cell in Bold |
| 5 | Control + C | Copy Highlighted Cell |
| 6 | Control + D | Fill the selected cell with the content of the cell right above. |
| 7 | Control + F | Shortcut to Find in Find and Replace Window |
| 8 | Control + G | Shortcut to Go to Window |
| 9 | Control + H | Shortcut to Replace in Find and Replace Window |
| 10 | Control + I | Shortcut to Make the content italic |
| 11 | Control + K | Insert Hyperlink in a Cell |
| 12 | Control + L | To Create New Table |
| 13 | Control + P | Print a Workbook |
| 14 | Control +R | Fill the selected cell with the content of the cell on the left. |
| 15 | Control + U | Underline Highlighted Text |
| 16 | Control + V | To paste anything that was copied |
| 17 | Control + W | Close the current Workbook |
| 18 | Control + Y | To undo Control + Z |
| 19 | Control + Z | To Undo Recent Action |
| 20 | Control + 1 | To Open Format Cell Window |
| 21 | Control + 2 | Alternative to Control + B |
| 22 | Control + 3 | Alternative to Control + I |
| 23 | Control + 4 | To underline the selected cell text |
| 24 | Control + 5 | Put a strikethrough in a cell. |
| 25 | Control + 8 | To show the outline symbols. |
| 26 | Control + 9 | Hide a Row |
| 27 | Control + 0 | Hide a Column |
| 28 | Control + Shift + : | Enter the current time in a cell. |
| 29 | Control + ; | Enter the current date in a cell. |
| 30 | Control + Shift + “ | Copy the formula from the cell above. |
| 31 | Control + – | Delete Column or Row |
| 32 | Control + Shift + + | Insert Column or Row |
| 33 | Control + Shift + ~ | Switch between displaying Excel formulas or their values in the cell. |
| 34 | Control + Shift + @ | To apply time formatting. |
| 35 | Control + Shift + ! | To apply Comma Formatting in numbers in the cell. |
| 36 | Control + Shift + $ | To apply Currency formatting in the cell. |
| 37 | Control + Shift + # | To apply date formatting in the cell. |
| 38 | Control + Shift + % | To apply percentage formatting in the cell. |
| 39 | Control + Shift + & | To apply the border in the cell. |
| 40 | Control + Shift + _ | To remove the border from the cell. |
| 41 | Control + Spacebar | To select the entire column. |
| 42 | Control + Shift + Spacebar | To select the entire sheet. |
| 43 | Control + Home | To move to cell A1. |
| 44 | Control + Shift + Tab | Switch to the previous workbook. |
| 45 | Control + Shift + F | Open the fonts menu under format cells. |
| 46 | Control + Shift + O | Select the cells containing comments. |
| 47 | Control + Drag | Drag and copy a cell or to a duplicate worksheet. |
| 48 | Control + Shift + Drag | Drag and insert copy. |
| 49 | Control + Up Arrow | To go to the topmost cell in a current column. |
| 50 | Control + Down Arrow | To jump to the last cell in a current column. |
| 51 | Control + Left Arrow | To jump back to the first cell in a selected row. |
| 52 | Control + Right Arrow | To go to the last cell in a selected row. |
| 53 | Control + End | To go to the last cell in a workbook. |
| 54 | Alt + Page down | To move the screen towards the right. |
| 55 | Alt + Page Up | To move the screen towards the Left. |
| 56 | Control + F2 | To open print preview Window. |
| 57 | Control + F1 | To expand or collapse the ribbon. |
| 58 | Alt | To see the Shortcuts for Menu and Toolbox. |
| 59 | Tab | To move to the next cell. |
| 60 | Alt + F + T | To open the options. |
| 61 | Alt + Down Arrow | Activate Filters for Cell. |
| 62 | Alt + H + H | To open the background color pallet. |
| 63 | Alt + H + B | To open the cell border pallet. |
| 64 | Alt + M + F | To insert a function. |
| 65 | Alt + A + V + V | To open the data validation window. |
| 66 | Alt + A + R + A | To refresh the sheet. |
| 67 | Alt + F + C | To close the Microsoft Excel. |
| 68 | Alt + N + V | To create a pivot table. |
| 69 | Alt + M + U + S | To enter the sum formula in the cell. |
| 70 | Alt + M + U + A | To enter the average formula in the cell. |
| 71 | Alt + M + U + C | To enter the count numbers formula in the cell. |
| 72 | Alt + M + U + M | To enter the max formula in the cell. |
| 73 | Alt + M + U + I | To enter the min formula in the cell. |
| 74 | Alt + M + U + F | To insert formula in the cell. |
| 75 | Control + Alt + + | To zoom into the sheet. |
| 76 | Control + Alt + – | To zoom out from the sheet. |
| 77 | Alt + 1 | To turn on autosave. |
| 78 | Alt + 2 | To save the workbook. |
| 79 | Alt + F + E | To export the workbook. |
| 80 | Alt + F + Z | To share the workbook. |
| 81 | Alt + Y + W | To know what’s new in Microsoft Excel. |
| 82 | Alt + Y + H | To open the help menu. |
| 83 | Alt + R + C | To add a comment into the cell. |
| 84 | Alt + P + O | To change the page orientation. |
| 85 | Alt + N + T | To insert a table. |
| 86 | Alt + H + 5 | To align the cell text to the left. |
| 87 | Alt + H + 6 | To align the cell text to the right. |
| 88 | Alt + M + T | To find text formulas. |
| 89 | Alt + M + K | To find error checking. |
| 90 | Alt + M + N | To open name manager. |
| 91 | Alt + M + L | To find logical functions. |
| 92 | Alt + M + I | To find account functions. |
| 93 | Alt + H + FC | To open text color pallet. |
| 94 | Alt + H + AR | To align the text to the right. |
| 95 | Alt + H + AL | To align the text to the left. |
| 96 | Alt + H + AC | To align the text to the center. |
| 97 | Alt + A + X | To check existing connections. |
| 98 | Alt + M + K | To do error checking. |
| 99 | Alt + A + SS | To open the sorting window. |
| 100 | Alt + P + M | To set the page margin. |
I hope the Excel shortcuts in this article will be helpful for you. Please leave a comment for any suggestions or feedback. Check out our previous articles as well.
Suggested Article – What is Vlookup and how to use it?
