Friday, 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.

No comments: