The POWER of the CTRL key !!!!!!!!!!!!
Practicing the CTRL SHIFT shortcuts will save tons of time:
CTRL SHIFT : Enters the time
CTRL SHIFT & Creates an outline box around whatever you select
CTRL SHIFT _ Removes the outline box around whatever has an outline
CTRL SHIFT * Highlights all the text surrounding the cell filled with data or numbers
CTRL SHIFT ! Applies the number format to selected cells
CTRL SHIFT % Applies the percentage format to the selected cells
CTRL SHIFT # Applies the date format to the selected cells
CTRL SHIFT @ Applies the time format to the selected cells
CTRL SHIFT ( Unhide columns that are selected
CTRL SHIFT ) Unhide rows that are selected
The best way to practice these is to simply type some numbers into a cell and then to press CTRL SHIFT plus the keys 1 – 10…since every number plus SHIFT (which is already pressed) will change it to the symbol, you can sample every trick quickly in this way.
Here are a few other CTRL shortcuts that can save time:
CTRL ; Enters the date
CTRL 9 Hide Rows selected
CTRL 0 Hide Columns selected
CTRL D Fills down current formula into all adjacent cells; this avoids copying first
CTRL K Insert a hyperlink
Post a Comment