Excel Shortcuts
Who doesn't like shortcuts!!! As we use Microsoft Excel in our day-to-day office works to create charts, analyze data, run a report and so many other crucial works; having knowledge of keyboard shortcuts for Excel can help users navigate, select, format, and enter formulas with less time consumption and effortlessly. Even if you are well familiar with the workability of Microsoft Excel, you will be surprised by how these Excel Shortcuts will make your Excel operation more convenient and give you a pro look among your colleagues. Here is a complete list of extremely useful keyboard combo available in Excel for your acknowledgment mentioned further below here. Knowing these Excel shortcuts will help you save a great amount of time so that you can focus more on operations that really matter.
Keyboard Shortcuts for Excel
Shortcut |
Description |
|
|---|---|---|
| 1 | Ctrl+A |
It is used to Select all the contents of a worksheet. |
| 2 | Ctrl+B |
It is used to Bold all cells in the highlighted section. |
| 3 | Ctrl+C |
It is used to Copy all cells in the highlighted section. |
| 4 | Ctrl+O |
It helps in Opens a workbook. |
| 5 | Ctrl+F |
It is used to Search current sheet. |
| 6 | Ctrl+G |
It is used to Go to a particular area. |
| 7 | Ctrl+H |
It is used to Find and replace. |
| 8 | Ctrl+I |
It is used to italics on all cells in the selected section. |
| 9 | Ctrl+K |
It is used to Inserts a hyperlink. |
| 10 | Ctrl+N |
It is used to Creates a new workbook. |
| 11 | Ctrl+P |
It is used to Print the current page. |
| 12 | Ctrl+D |
Fill Down |
| 13 | Ctrl+R |
Fill Right |
| 14 | Ctrl+S |
It is used to Save the current sheet. |
| 15 | Ctrl+U |
It is used to Underline the all selected section. |
| 16 | Ctrl+V |
It is used to Paste the copied contents |
| 17 | Ctrl+W |
Closes the current page. |
| 18 | Ctrl+X |
It is used to Cut the selected cells. |
| 19 | Ctrl+Y |
It is used to Repeats the last entry. |
| 20 | Ctrl+Z |
It is used to Undo the last action. |
| 21 | Ctrl+1 |
It is used to Changes the format of the selected cells. |
| 22 | Ctrl+2 |
Bolds all cells |
| 23 | Ctrl+3 |
Puts italics highlighted cells. |
| 24 | Ctrl+4 |
It is used to Underlines all cells in the highlighted section. |
| 25 | Ctrl+6 |
It is used to Hides or Shows objects. |
| 26 | Ctrl+7 |
It is used to Hides or Shows the toolbar. |
| 27 | Ctrl+8 |
Toggles the outline symbols |
| 28 | Ctrl+9 |
It is used to Hides rows. |
| 29 | Ctrl+0 |
It is used to Hides columns. |
| 30 | Ctrl+Shift+: |
It is used to insert the current time. |
| 31 | Ctrl+; |
It is used to Enter the current date. |
| 32 | Ctrl+Shift+" |
It is used to Copies value from the cell above. |
| 33 | Ctrl+- |
It is used to Deletes the selected row/column. |
| 34 | Ctrl+Shift+= |
It is used to Inserts a new column/row. |
| 35 | Ctrl+Shift+@ |
Applies time formatting. |
| 36 | Ctrl+Shift+& |
Add a Border around selected cells. |
| 37 | Ctrl+Shift+_ |
It is used to remove a border. |
| 38 | Ctrl+Home |
It is used to Move to cell A1. |
| 39 | Ctrl+End |
It is used to Move to the last cell. |
| 40 | Ctrl+Shift+A |
It is used to Inserts argument names into a formula. |
| 41 | Shift+Page Up |
Highlights all cells above that are selected in a single column. |
| 42 | Shift+Page Down |
Highlights all cells above that are selected in a single column. |
| 43 | F1 |
It is used to Open help menu. |
| 44 | F4 |
Repeat last Action |
| 45 | Alt+F1 |
It is used to Insert a Chart. |
| 46 | Alt+F8 |
It is used to Opens the macro dialog box. |