![keyboard shortcut for excel tabs keyboard shortcut for excel tabs](https://cdn.corporatefinanceinstitute.com/assets/10202020-Basic-Excel-Formulas@1x.png)
Ctrl+Space: Use this to select the whole column.Shift+Space: Use this to select the whole row.Ctrl+Shift+Spacebar: Use this in order to select the whole worksheet.Ctrl+End: Use this to navigate to the most bottom right used cell.Tab: Use this to switch to the next cell.Shift+Tab: Use this to switch to the previous cell.Ctrl+Alt+F5: Use this to refresh everything in the workbook.Ctrl+Alt+F9:Use this in order to calculate all worksheets in every open workbook.Ctrl+Shift+End: Use to select the entire text in the formula bar.Ctrl+Shift+Asterisk (*): Use this to select the current region near the active or highlighted cell.Ctrl+Shift+Enter : Use this insert array formula.Ctrl+Shift+ampersand (&): Use it to apply an outline border to the highlighted cells.Ctrl+Shift+underline (_): Use this to remove the outline border from the highlighted cells.Ctrl+Shift+caret sign (^) : Use this to use Scientific number format.
![keyboard shortcut for excel tabs keyboard shortcut for excel tabs](https://i.ytimg.com/vi/OEpnene0SmE/maxresdefault.jpg)
![keyboard shortcut for excel tabs keyboard shortcut for excel tabs](https://www.officeoneonline.com/xlsctmgr/xlsctmgr_customize_shortcuts.png)
Ctrl+Tab: Use this to switch from one open workbook to another.Ctrl+F: Use this to find & replace something in the spreadsheet.F1: Use this to open the Microsoft Excel help window.Ctrl+F2: use this to Switch to Print Preview.Ctrl + 5: Use this to put a strikethrough in a highlighted cell.Ctrl + U: Use this to add underline to any specific cells.Ctrl + K: Use this to insert a hyperlink in any specific cell.Ctrl + I: Use this To italicize any highlighted cell contents.Ctrl + P: Use this to print a workbook.Ctrl+F9: Use this to minimize the workbook window.Ctrl+8: Use this to display or hide the outline symbols.Ctrl+1: Use this to open the Format Cells dialog.Alt+F8: Use this to open the macro dialog box.Alt+X: Use this to go to the add-ins tab.Alt+M: Use this to go to the Formulas tab.Alt+P: Use this to go to the Page Layout tab.Alt+F: Use this to open the File tab menu.Ctrl+0: Use this to hide the selected columns.Ctrl+9: Use this to hide the selected rows.Ctrl + H: Use this to find and replace cell contents.Ctrl + B: Use this to bold any highlighted cells.Ctrl + N: Use this to create a new workbook.Ctrl+V: Use this to paste anything which was copied.Ctrl + C: Use this to copy highlighted cells.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.