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
- Ctrl + C: Use this to copy highlighted cells.
- Ctrl+V: Use this to paste anything which was copied.
- Ctrl + N: Use this to create a new workbook.
- Ctrl + S: Use this save a workbook.
- Ctrl + B: Use this to bold any highlighted cells.
- Ctrl+W: Use this to close a workbook.
- Ctrl + H: Use this to find and replace cell contents.
- Ctrl+9: Use this to hide the selected rows.
- Ctrl+0: Use this to hide the selected columns.
- Alt+H: use this to go to the home tab.
- Alt+F: Use this to open the File tab menu.
- Alt+P: Use this to go to the Page Layout tab.
- Alt+A: Use this to go to the Data tab.
- Alt+W: Use this to go to the View tab.
- Alt+M: Use this to go to the Formulas tab.
- Alt+X: Use this to go to the add-ins tab.
- Alt+Y: Use this to go to the Help tab.
- Alt+F8: Use this to open the macro dialog box.
- Ctrl+1: Use this to open the Format Cells dialog.
- Ctrl+8: Use this to display or hide the outline symbols.
- Ctrl+F9: Use this to minimize the workbook window.
- Ctrl + P: Use this to print a workbook.
- Ctrl + I: Use this To italicize any highlighted cell contents.
- Ctrl + K: Use this to insert a hyperlink in any specific cell.
- Ctrl + U: Use this to add underline to any specific cells.
- Ctrl + 5: Use this to put a strikethrough in a highlighted cell.
- Ctrl+F2: use this to Switch to Print Preview.
- F1: Use this to open the Microsoft Excel help window.
- F7: Use this Check your spelling.
- Ctrl+F: Use this to find & replace something in the spreadsheet.
- Ctrl+Tab: Use this to switch from one open workbook to another.
- Ctrl+F4: Use this to close Excel
- Ctrl+Left or Right Arrow: Use this move to the first and last of each range in a row or column.
- Ctrl+Up or Down Arrow: use this to move to the top or bottom cell of any specified column.
- Ctrl + Mouse Wheel Up: Use this to zoom in.
- 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
- Ctrl+Shift+percent sign (%) : Use this to apply the percentage format.
- Ctrl+Shift+number sign (#): Use this to apply day, month, and year (Date format).
- Ctrl+Shift+at sign (@): use this to apply hour and minute, and AM or PM (Time format).
- Ctrl+Shift+tilde sign (~): Use this to apply or use the General number format.
- Ctrl+Shift+caret sign (^) : Use this to use Scientific number format.
- Ctrl+Shift+underline (_): Use this to remove the outline border from the highlighted cells.
- Ctrl+Shift+ampersand (&): Use it to apply an outline border to the highlighted cells.
- Ctrl+Shift+Enter : Use this insert array formula.
- Ctrl+Shift+Asterisk (*): Use this to select the current region near the active or highlighted cell.
- Ctrl+Shift+End: Use to select the entire text in the formula bar.
- Ctrl+Alt+F9:Use this in order to calculate all worksheets in every open workbook.
- Ctrl+Alt+F5: Use this to refresh everything in the workbook.
- Shift+Tab: Use this to switch to the previous cell.
- Tab: Use this to switch to the next cell.
- Ctrl+End: Use this to navigate to the most bottom right used cell.
- Ctrl+Shift+Spacebar: Use this in order to select the whole worksheet.
- Shift+Space: Use this to select the whole row.
- Ctrl+Space: Use this to select the whole column.
- Alt+H+B: Use This to add a border.
- Alt+H+H: Use this to select any fill color.
- Ctrl+Shift+F: Use this format fonts using the Format Cells dialog.
- Ctrl+Shift+Plus sign (+) : Insert blank cells using insert dialog.
- Ctrl+Minus sign (-): Delete Highlighted or selected cells using delete dialog.
- 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.