Excel Keyboard shortcuts – Control, Ctrl Keys

CTRL+A    Selects ALL
CTRL+B    Apply BOLD Formatting.
CTRL+C    COPY selected cells
CTRL+D    FILL DOWN – Copies the format of the top cell of the range to  the selected cells
CTRL+F     Displays the FIND dialog box.
CTRL+G     GO TO dialog box.
CTRL+H    FIND & REPLACE dialog box
CTRL+I    Apply or remove ITALICS formatting.
CTRL+K    Insert HYPERLINK dialog box or the Edit Hyperlink dialog box
CTRL+L    Create LIST dialog box.
CTRL+N    Open and creates a NEW workbook.
CTRL+O    Displays the OPEN dialog box to open or find a file.
CTRL+P    PRINT dialog box
CTRL+R    FILL RIGHT command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+S    SAVE file with current file specifications
CTRL+U   Apply or remove UNDERLINING
CTRL+V   PASTE
CTRL+W   Close workbook WINDOW
CTRL+X    CUT selected cells
CTRL+Y    Repeats the last command
CTRL+Z    UNDO command

Source: Microsoft Office Online

Advertisements
Explore posts in the same categories: Excel - Helpful Hints & Tips

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

You can comment below, or link to this permanent URL from your own site.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: