keyboard shortcuts for excel

60+ Best keyboard shortcuts for excel

by

If you are a Microsoft Excel user then sometimes it can be a difficult task to do small tasks without any shortcut as it might even disturb the workflow, Therefore I have curated a list of 60+ Best keyboard shortcuts for excel.You can use these keyboard shortcuts for excel to increase productivity and improve your workflow.

Best Basic Keyboard Shortcuts for Excel

  1. Ctrl + C: Use this to copy highlighted cells.
  2. Ctrl+V:  Use this to paste anything which was copied.
  3. Ctrl + N: Use this to create a new workbook.
  4.  Ctrl + S: Use this save a workbook.
  5. Ctrl + B: Use this to bold any highlighted cells.
  6. Ctrl+W:  Use this to close a workbook.
  7. Ctrl + H: Use this to find and replace cell contents.
  8. Ctrl+9: Use this to hide the selected rows.
  9. Ctrl+0: Use this to hide the selected columns.
  10. Alt+H:  use this to go to the home tab.
  11. Alt+F: Use this to open the File tab menu.
  12. Alt+P:  Use this to go to the Page Layout tab.
  13. Alt+A:  Use this to go to the Data tab.
  14. Alt+W: Use this to go to the View tab.
  15. Alt+M: Use this to go to the Formulas tab.
  16. Alt+X: Use this to go to the add-ins tab.
  17. Alt+Y: Use this to go to the Help tab.
  18. Alt+F8: Use this to open the macro dialog box.
  1. Ctrl+1: Use this to open the Format Cells dialog.
  2. Ctrl+8: Use this to display or hide the outline symbols.
  3. Ctrl+F9: Use this to minimize the workbook window.
  4. Ctrl + P: Use this to print a workbook.
  5. Ctrl + I: Use this To italicize any highlighted cell contents.
  6. Ctrl + K: Use this to insert a hyperlink in any specific cell.
  7. Ctrl + U: Use this to add underline to any specific cells.
  8. Ctrl + 5: Use this to put a strikethrough in a highlighted cell.
  9. Ctrl+F2: use this to Switch to Print Preview.
  10. F1: Use this to open the Microsoft Excel help window.
  11. F7: Use this Check your spelling.
  12. Ctrl+F: Use this to find & replace something in the spreadsheet.
  13. Ctrl+Tab: Use this to switch from one open workbook to another.
  14. Ctrl+F4: Use this to close Excel
  15. Ctrl+Left or Right Arrow: Use this move to the first and last of each range in a row or column.
  16. Ctrl+Up or Down Arrow: use this to move to the top or bottom cell of any specified column. 
  17. Ctrl + Mouse Wheel Up:  Use this to zoom in.
  18. Ctrl + Mouse Wheel Down: Use this to zoom out.

Also Read : 15 Best Starter Themes for WordPress for Developers

some of the Best (Advanced) Keyboard Shortcuts For Excel

  1. Ctrl+Shift+percent sign (%) : Use this to apply the percentage format.
  2. Ctrl+Shift+number sign (#): Use this to apply day, month, and year (Date format).
  3. Ctrl+Shift+at sign (@): use this to apply hour and minute, and AM or PM (Time format).
  4. Ctrl+Shift+tilde sign (~): Use this to apply or use the General number format.
  5. Ctrl+Shift+caret sign (^) : Use this to use Scientific number format.
  6. Ctrl+Shift+underline (_): Use this to remove the outline border from the highlighted cells.
  7. Ctrl+Shift+ampersand (&): Use it to apply an outline border to the highlighted cells.
  8. Ctrl+Shift+Enter : Use this insert array formula.
  9.  Ctrl+Shift+Asterisk (*): Use this to select the current region near the active or highlighted cell.
  10. Ctrl+Shift+End: Use to select the entire text in the formula bar.
  11. Ctrl+Alt+F9:Use this in order to calculate all worksheets in every open workbook.
  12. Ctrl+Alt+F5: Use this to refresh everything in the workbook.
  1. Shift+Tab: Use this to switch to the previous cell.
  2. Tab: Use this to switch to the next cell.
  3. Ctrl+End: Use this to navigate to the most bottom right used cell.
  4. Ctrl+Shift+Spacebar: Use this in order to select the whole worksheet.
  5. Shift+Space:  Use this to select the whole row.
  6.  Ctrl+Space:  Use this to select the whole column.
  7. Alt+H+B: Use This to add a border.
  8. Alt+H+H: Use this to select any fill color.
  9. Ctrl+Shift+F: Use this format fonts using the Format Cells dialog.
  10. Ctrl+Shift+Plus sign (+) : Insert blank cells using insert dialog.
  11. Ctrl+Minus sign (-): Delete Highlighted or selected cells using delete dialog.
  12. Ctrl+Shift+$: Use this use or apply the currency format.

6 Best Android Emulators For PC And Mac In 2021

Wrapping Up:

There are more Keyboard Shortcuts for Excel but these are the most used / most important. I could have included more of them but I think 60+ Keyboard Shortcuts for Excel is more than enough to increase your workflow in Excel. Use these Keyboard Shortcuts for Excel And Let me know which you use the most.

Get Excel Here

Leave a Comment