62 Excel Shortcuts to Save You Time, It’s like your little helpers in the digital world! They save you time, crunch numbers, and organize data faster than you can wink. With formulas like SUM for adding, IF for decisions, and VLOOKUP for finding info, you’ll handle tasks like a boss. In today’s world, knowing Excel is practically a superpower!
| Shortcut Keys | Function |
| Ctrl + N = | Create a new workbook |
| Ctrl + B = | Bold |
| Ctrl + I = | Italics |
| Ctrl + U = | Underline |
| Ctrl + C = | Copy |
| Ctrl + V = | Paste |
| Ctrl + F = | Search |
| Ctrl + H = | Find and replace |
| Ctrl + O = | Open an existing workbook |
| Ctrl + S = | Save |
| Ctrl + W = | Close a workbook |
| Ctrl + K = | Insert a hyperlink |
| Ctrl + X = | Cut the content |
| Ctrl + Y = | Redo |
| Ctrl + Z = | Undo |
| Ctrl + F1 = | Show or hide the ribbon |
| Ctrl + F2 = | Open Print preview |
| Ctrl + F4 = | Close |
| Ctrl + F9 = | Minimize workbook |
| Ctrl + F10 = | Restore workbook |
| Ctrl + 9 = | Hide Row |
| Ctrl + 0 = | Hide Column |
| Ctrl + Shift + ; = | Insert the time in the active cell |
| Ctrl + Shift + # = | Insert Date format (dd/mm/yyyy) |
| Ctrl + Shift + $ = | Currency format |
| Ctrl + Shift + % = | Percentage format |
| Ctrl + Shift + & = | Apply outline border |
| Ctrl + Shift + _ = | Remove outline border |
| Ctrl + Shift + Space = | Select entire workbook |
| Ctrl + Space = | Select the entire column |
| Shift + Space = | Select the entire row |
| Ctrl + Shift + L = | Data filter |
| Ctrl + Shift + C = | Unhide any rows in the selected area |
| Ctrl + Shift + ) = | Unhide any columns in the selected area |
| Ctrl + Shift + UpArrow = | Move to the top cell of the column |
| Ctrl + DownArrow = | Move to the bottom of column |
| Ctrl + Alt + = | Zoom in |
| Ctrl + Alt – = | Zoom out |
| Ctrl + Alt + Shift = | Check dependent formula |
| Alt + Tab = | Move to other applications |
| Ctrl + PgUp = | Move to the previous sheet |
| Ctrl + PgDn = | Move to the next sheet |
| Ctrl + Home = | Move to the beginning of the workbook |
| Ctrl + End = | Move to the bottom-right used cell |
| Alt + H + I + S = | New worksheet |
| Alt + H + H = | Cell color |
| Alt + H + F + C = | Font color |
| Alt + H + F + S = | Font size |
| Alt + N + V = | Insert Pivot Table |
| Alt + H + D + U + S = | Hide a sheet |
| Alt + H + O + U + H = | Unhide a sheet |
| Alt + H = | Go to Home tab |
| Alt + W = | Go to Formula tab |
| Alt + P = | Open the Page Layout |
| Alt + F8 = | Macros |
| Alt + M + D = | Formula tracing |
| Alt + W + F + F = | Freeze/Unfreeze panes |
| Alt + F1 = | Insert chart |
| Alt + N + C = | Insert column chart |
| Alt + H + D + S = | Delete a worksheet |
| Alt + A + E + F = | Text to columns |
| Ctrl + A = | Select all content |
That’s It! We hope you find the Excel shortcuts useful; you can also read about X(twitter) shortcuts. Watch this space for additional content in the future. Do not forget to share this post on social media. Until next time, happy browsing!
