Power of CTRL key in Excel

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

Related posts:

1. Useful Tips in Excel
2. Quickly Access to other functionality of Microsoft Excel with Cells Assistant for Excel Plugin
3. Copying Excel into Powerpoint
4. 20+ Microsoft Excel Printing Tips
5. Adding Drop-Down List in Excel
6. How to Hide the Worksheet ?
7. Conditional Formatting in Excel
8. Remove Password from Excel files – Excel Add-in
9. Smart XL-Send bulk SMS directly from Microsoft Excel
10. Download Windows Home Server Power Pack 1