#Basic Shortcut keys of Excel
#51 Must Know Excel Shortcut Key
In this article, we will discuss 51 shortcuts on excel that can be done using the Excel.
If you have knowledge of these shortcut keys than you can smoothly work on excel.
| Sl No. | Excel Shortcuts Keys | Excel Shortcut Function |
| 1 | Ctrl + N: | To create a new workbook. |
| 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. |
| 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. |
| 8 | Ctrl + F: | To search for anything in a workbook. |
| 9 | Ctrl + H: | To find and replace cell contents. |
| 10 | Ctrl + I: | To italicise cell contents. |
| 11 | Ctrl + K: | To insert a hyperlink in a cell. |
| 12 | Ctrl + P: | To print a workbook. |
| 13 | Ctrl + U: | To underline highlighted cells. |
| 14 | Ctrl + V: | To paste anything that was copied. |
| 15 | Ctrl + W: | To close your current workbook. |
| 16 | Ctrl + Z: | To undo the last action. |
| 17 | Ctrl + 1: | To format the cell contents |
| 18 | Ctrl + 5: | To put a strikethrough in a cell. |
| 19 | Ctrl + 9: . | To hide a row |
| 20 | Ctrl + Spacebar: | To select an entire column. |
| 21 | Ctrl + Shift + Spacebar: | To select an entire workbook. |
| 22 | Ctrl + Home: | To redirect to cell A1. |
| 23 | Ctrl + Shift + Tab: | To switch to the previous workbook. |
| 24 | Ctrl + Shift + F: | To open the fonts menu under format cells. |
| 25 | Ctrl + End: | To go to the last cell in a workbook. |
| 26 | Ctrl + F2: | To open the print preview window. |
| 27 | Ctrl + F1: | To expand or collapse the ribbon. |
| 28 | F2: | To edit a cell. |
| 29 | Shift + F2: | To add or edit a cell comment. |
| 30 | Alt + H + H: | To select a fill colour. |
| 31 | Alt + H + B: | To add a border. |
| 32 | Shift + Space: | To select the entire row. |
| 33 | Alt + H: | To go to the Home tab in Ribbon. |
| 34 | Alt + N: | To go to the Insert tab in Ribbon. |
| 35 | Alt + P: | To go to the Page Layout tab in Ribbon. |
| 36 | Alt + M: | To go to the Formulas tab in Ribbon. |
| 37 | Alt + A: | To go to the Data tab in Ribbon. |
| 38 | Alt + R: | To go to the Review tab in Ribbon. |
| 39 | Alt + W: | To go to the View tab in Ribbon. |
| 40 | Alt + Y: | To open the Help tab in Ribbon. |
| 41 | Alt + Enter: | To start a new line in a current cell. |
| 42 | Shift + F3: | To open the Insert function dialog box. |
| 43 | F9: | To calculate workbooks. |
| 44 | Alt + 1: | To turn on Autosave. |
| 45 | Alt + 2: | To save a workbook. |
| 46 | Alt + F + E: | To export your workbook. |
| 47 | Alt + F + Z: | To share your workbook. |
| 48 | Alt + F + C: | To close and save your workbook. |
| 49 | Ctrl+Tab | Move between Two or more open Excel files. |
| 50 | F1: | To open Microsoft Excel help. |
| 51 | Ctrl + F4: | To close Microsoft Excel. |
NOTE: In case of any query, please feel free to contact me on this email enquiry@overallaccounting.com
