| CTRL+SHIFT+A |
Inserts argument names into a formula. |
| CTRL+SHIFT+F |
Opens the drop-down menu for fonts. |
| CTRL+SHIFT+O |
Selects all of the cells that contain comments. |
| CTRL+SHIFT+P |
Opens the drop-down menu for point size. |
| CTRL+SHIFT+F3 |
Creates names by using those of either row or column labels. |
| CTRL+SHIFT+F6 |
Moves to the previous worksheet window. |
| CTRL+SHIFT+F12 |
Prints the current worksheet. |
| CTRL+SHIFT+Spacebar |
Selects the entire worksheet. |
| CTRL+SHIFT+Tab |
Activates the previous workbook. |
| CTRL+SHIFT+ : |
Enters the current time. |
| CTRL+SHIFT+ " |
Copies value from cell above. |
| CTRL+SHIFT+ = |
Inserts a new column or row. |
| CTRL+SHIFT+ ~ |
Switches between showing Excel formulas or their values in cells. |
| CTRL+SHIFT+ @ |
Applies time formatting. |
| CTRL+SHIFT+ ! |
Applies comma formatting. |
| CTRL+SHIFT+ $ |
Applies currency formatting. |
| CTRL+SHIFT+ # |
Applies date formatting. |
| CTRL+SHIFT+ % |
Applies percentage formatting. |
| CTRL+SHIFT+ ^ |
Applies exponential formatting. |
| CTRL+SHIFT+ * |
Selects the current region around the active cell. |
| CTRL+SHIFT+ & |
Places border around selected cells. |
| CTRL+SHIFT+ _ |
Removes a border. |
| CTRL+SHIFT+ ( |
Unhide rows. |
| CTRL+SHIFT+ ) |
Unhide columns. |
| CTRL+SHIFT+ { |
Selects all cells directly or indirectly referenced by formulas in the highlighted section. |
| CTRL+SHIFT+ } |
Selects cells which contain formulas that directly or indirectly reference the active cell. |
The GuideBox is a brand new community where we share the best of our knowledge with all you amazing people.
No comments:
Post a Comment