Friday, December 16, 2005

Using the CTRL Key

I was going to write another article about letting go the mouse. But instead I am going to point you to Jeff Dance's Excel Tricks blog where he has written a great article on using the CTRL key.

Ctrl + 1       Enter the format dialog box for most formatting
Ctrl + Shift + F       Enter the format dialog box for formatting font without having to stretch the finger for Ctrl + 1
Alt + Shift + F1       Insert New Worksheet
F7       Spell check selected text and or document.
F11       Create chart.
Ctrl + Shift +       Enter the current time
Ctrl +       Enter the current date
Shift + F3       Open the Excel formula window.
Shift + F5       Bring up search box.
Ctrl + A       Select all contents of the worksheet.
Ctrl + B       Bold highlighted selection.
Ctrl + I       Italic highlighted selection.
Ctrl + K       Insert link.
Ctrl + U       Underline highlighted selection.
Ctrl + 5       Strikethrough highlighted selection.
Ctrl + P       Bring up the print dialog box to begin printing.
Ctrl + Z       Undo last action.
Ctrl + F9       Minimize current window.
Ctrl + F10       Maximize currently selected window.
Ctrl + F6       Switch between open workbooks / windows.
Ctrl + Page up       Move between Excel work sheets in the same Excel document.
Ctrl + Page down       Move between Excel work sheets in the same Excel document.
Ctrl + Tab       Move between Two or more open Excel files.
Ctrl + Shift + !       Format number in comma format.
Ctrl + Shift + $       Format number in currency format.
Ctrl + Shift + #       Format number in date format.
Ctrl + Shift + %       Format number in percentage format.
Ctrl + Shift + ^       Format number in scientific format.
Ctrl + Shift + @       Format number in time format.
Ctrl + Arrow key       Move to next section of text.
Ctrl + Space       Select entire column.
Shift +       Space Select entire row.


Posted by: Jethro | 10:09 PM |