Excel Keyboard Shortcuts :
Hide / Unhide Group Shortcut:
| Shortcut Key | Description |
|---|---|
| CTRL+9 | Hide the selected row(s) |
| CTRL+SHIFT+( | Unhide any hidden row(s) within selection |
| CTRL+0 | Hide the selected column(s) |
| CTRL+SHIFT+) | Unhide any hidden column(s) within selection |
Navigation shortcuts:
| Shortcut Key | Description |
|---|---|
| HOME | Move to the beginning of the Row |
| CTRL+HOME | Move to the beginning of the Worksheet |
| CTRL+END | Move to the bottom-most and right-most used cell in the Worksheet |
| CTRL+PAGDOWN | Move to the Next Sheet in the workbook |
| CTRL+PAGEUP | Move to the Pervious Sheet in the workbook |
| ALT+PAGEDOWN | Move one screen to the Right |
| ALT+PAGEUP | Move one screen to the Left |
Selection shortcuts:
| Shortcut Key | Description |
|---|---|
| CTRL+SHIFT+PAGEDOWN | Select the current sheet and next sheet |
| CTRL+SHIFT+PAGEUP | Select the current sheet and previous sheet |
| CTRL+SPACE | Select the entire COLUMN |
| SHIFT+SPACE | Select the entire ROW |
| CTRL+* | Select current range |
| CTRL+SHIFT+O(letter O) | Select cells that contain Comments |
| CTRL+SHIFT+* | Select the current region around the active cell |
| CTRL+ / | Select the array containing the active cell |
| CTRL+] | Select all cells that contain formulae that directly reference active cell |
| CTRL+SHIFT+} | Select all cells that contain formulae that directly or indirectly reference active cell. |
Date & Time related shortcuts:
| Shortcut Key | Description |
|---|---|
| CTRL+; | Insert current date |
| CTRL+SHIFT+: (COLON) | Insert current time |
Number Formatting shortcuts:
| Shortcut Key | Description |
|---|---|
| CTRL+SHIFT+~ | General Format the numbers in selected range |
| CTRL+SHIFT+% | Apply Percentage format to numbers in selected range |
| CTRL+SHIFT+$ | Apply Currency format to numbers in selected range |
| CTRL+SHIFT+# | Apply date format (dd/mm/yy) to the selected cell(s) |
| CTRL+SHIFT+^ | Apply Exponential number format with 2 decimal places to the selection |
| CTRL+SHIFT+! | Apply Number format with 2 decimal places, thousands separator and minus sign for -ve numbers. |
General Cell / Range Formatting shortcuts:
| Shortcut Key | Description |
|---|---|
| CTRL+1 | Format cells menu |
| CTRL+SHIFT+& | Apply outline border to the selection |
| CTRL+SHIFT+ _ (underscore) | Remove the outline border to the selection |
| CTRL+5 | Apply (or remove) Strikethrough format to the selection |
| CTRL+B OR CTRL+2 | Apply (or remove) Bold format |
| CTRL+B OR CTRL+3 | Apply (or remove) Italic format |
| CTRL+B OR CTRL+4 | Apply (or remove) Underline format |
Copy data shortcuts:
Shortcut Key
|
Description
|
|---|---|
CTRL+D
|
Fill Down
|
CTRL+R
|
Fill Right
|
CTRL+, (comma)
|
Copy formula from cell above to the active cell
|
CTRL+" (double quotes)
|
Copy value from cell above to the active cell
|
Other shortcuts:
| Shortcut Key | Description |
|---|---|
| CTRL+K | Insert hyperlink menu |
| CTRL+'(~) | Toggle formula view |
| F4 | Repeat last action |
| F11 | Chart selected data |
Follow @Sarvavasi.com