|
Hide / Unhide shortcuts: |
|
|
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: |
|
|
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: |
|
|
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: |
|
CTRL+; |
Insert current date |
|
CTRL+SHIFT+: (COLON) |
Insert current time |
|
Number Formatting shortcuts: |
|
|
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: |
|
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: |
|
|
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: |
|
|
CTRL+K |
Insert hyperlink menu |
|
CTRL+'(~) |
Toggle formula view |
|
F4 |
Repeat last action |
|
F11 |
Chart selected data |