Ctrl Keys

Ctrl + F3                  Define Name dialog box
Ctrl + F4                  Close Workbook
Ctrl + F5                  Restore Window
Ctrl + F6                  Next Workbook
Ctrl + F7                  Move Window
Ctrl + F8                  Resize Window
Ctrl + F9                  Minimize Window
Ctrl + F10                Restore Workbook
Ctrl + F11                New Macro Sheet
Ctrl + F12                Open dialog box
Ctrl + A                    Select All
Ctrl + B                    Bold Font
Ctrl + C                    Copy Selection
Ctrl + D                   Fill Down (Drag to Select)
Ctrl + F                    Find dialog box
Ctrl + G                   Goto dialog box
Ctrl + H                   Replace (Find dialog box)
Ctrl + I                     Italic Font
Ctrl + K                    Insert Hyperlink dialog box
Ctrl + N                   New Workbook
Ctrl + O                   Open dialog box
Ctrl + P                    Print
Ctrl + R                    Fill Right (Drag to Select)
Ctrl + S                    Save
Ctrl + U                    Underline Font
Ctrl + V                    Paste
Ctrl + W                    Close Workbook
Ctrl + X                    Cut Selection
Ctrl + Y                    Do Again
Ctrl + Z                    Undo
Ctrl + 1                    Format Cells dialog box
Ctrl + 2                    Bold Font
Ctrl + 3                    Italic Font
Ctrl + 4                    Underline Font
Ctrl + 5                    Strikethrough Font
Ctrl + 8                    Display Outline Symbols
Ctrl + 9                    Hide Rows
Ctrl + 0                    Hide Columns
Ctrl + -                    Delete dialog box
Ctrl + [                     Direct Dependents
Ctrl + ]                     All Dependents
Ctrl + ;                     Current Date
Ctrl + :                     Current Time
Ctrl + Home             Start of Worksheet
Ctrl + End                Final Cell
Ctrl + Page Up         Previous Worksheet
Ctrl + Page Down    Next Worksheet
Ctrl + Tab                Next Window

Push Ctrl while drawing Autoshapes to expand outwards (good for placing circles in precise locations)

Ctrl + Spacebar         Select Column

Ctrl + Mousewheel     Zoom/Unzoom 15% increments
Ctrl + Enter                Simultaneous entry into a range of cells

Ctrl + Arrow keys       Will help you move to the next value, end of selection or end of Worksheet quickly. Use these keys with Shift to select a range quickly.



© Copyright andrewsexceltips.net All Rights Reserved.