Posted by: Gomzy | December 29, 2006

Ctrl+Numerical Excel Keyboard Shortcuts

Short Cut Name
Ctrl+1 Open the Format Cells dialog box
Ctrl+2 Bold
Ctrl+3 Italics
Ctrl+4 Underline
Ctrl+5 Strike through the selection
Ctrl+6 Display Place Holders for Objects
Ctrl+7 Show /Hide Standard Tool Bar
Ctrl+8 Show Outline Symbols
Ctrl+9 Hide selected rows
Ctrl+0 Hide selected columns
Ctrl+. Blank
Ctrl+, Blank
Ctrl+’ Deletes the contents of the cell and prepares the same for Editing
Ctrl+/ Select the array containing the active cell.
Ctrl+` Show Formula
Ctrl+- Delete Cell/Row Similar to Edit>Delete
Ctrl+; Insert the current date
Ctrl+= Blank
Ctrl+[ Select cells that a selected formula directly references
Ctrl+] Select formulas that directly reference the active cell
Ctrl+\ In a selected row, select the cells that don’t match the value in the active cell.
Advertisements

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

Categories

%d bloggers like this: