Excel shortcuts are amazing. We love to learn and keep learning. But the fact we don't like is, we forget is even faster just for lack of practicing. What if, we maintain a table of MS Excel shortcut and keep updating it, and look back while we need a particular one to revisit! Well, here I share mine.
And I'll keep updating it while need to.
Area | Action | Description | Keys |
Anything | Redo | Redo | CTRL + Y |
Cell | Hide | Hide one more digit of the number after decimal | Alt, H, 9 |
Cell | Move | One Row Up | SHIFT + Enter |
Cell | Select | Select Cells: Select all Adjacent cells | CTRL + SHIFT + End |
Cell | Show | Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. | CTRL + SHIFT + 1 |
Cell | Show | Show one more digit of the number after decimal | Alt, H, 0 |
Column | Hide/Unhide | Hide/Unhide Column | CTRL + 0 / CTRL + SHIFT + 0 |
Column | Select | Select Whole Column | CTRL + Space |
Dialogue Box | Show | Appear Move or Copy Sheet Window | Alt, E, M |
Dialogue Box | Show | Displays the Save As dialog box. | F12 |
File | Move | Switches to the next workbook window when more than one workbook window is open. | CTRL + TAB or CTRL + F6 |
Filter | Add | Add/Remove filter | CTRL + SHIFT + L |
Format | Repeat | Repeats the last command or action, if possible. | F4 |
Formula | Add | Set Anchor ($) within a Formula. Use while your cursor in a cell in formula | F4 |
Formula | Show | % Shows | CRTL + SHIFT + 5 |
Formula | Show | Display Formulas | CTRL + ` |
Formula | Sum | Sum All together | Alt + "=" (Equal) |
Menu Bar | Hide/Unhide | Displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface. | CTRL + F1 |
Mouse Action | Show | Shows Right Click options, if you don't have mouse | SHIFT + F10 |
Pivot | Select | Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report. | CTRL + SHIFT + 8 |
Row | Select | Select Whole Row | SHIFT + Space |
Row | Hide/Unhide | Hide/Unhide Row | CTRL + 9 / CTRL + SHIFT + 9 |
Row/Column | Add | Add Row/Column (After selecting row/column) | CTRL + "+" (Plus) |
Row/Column | Freeze | Freeze Rows and Column | Alt, W, F, F |
Table | Border | Table All Borders to Selected Cells | Alt, H, B, A |
Work Sheet | Add | Add New Sheet | SHIFT + F11 |
Work Sheet | Delete | Deletes active Sheet | Alt, E, L |
Work Sheet | Hide | Hides Active/Selected Sheets | Alt, O, H, H |
Work Sheet | Rename | Rename Active Sheet | Alt, O, H, R |
Work Sheet | Select | Selects the current and next sheet in a workbook. | CTRL + SHIFT + PAGE UP/DOWN |
Work Sheet | Show | Show Hide/Unhide Sheet box | Alt, O, H, U |
Zoom View | Show | Appear Sheet Zoom View Dialogue Box | Alt, V, Z |
And I'll keep updating it while need to.
No comments:
Post a Comment