Back to Excel Solutions

Keyboard Commands for Excel

Ctrl+Enter+1 shows Format..Cells Dialog Box with other Format options
Ctrl+Enter+2 toggles Bold
Ctrl+Enter+3 toggles Italics
Ctrl+Enter+4 toggles underline
Ctrl+Enter+5 toggles strikethrough
Ctrl+Enter+6 toggles placeholder of sheet objects
Ctrl+Enter+7 toggles toolbar1
Ctrl+Enter+8 toggles outline
Ctrl+Enter+9 hides current row
Ctrl+Enter+0 hides current column
Ctrl+Enter+- Delete Option box
Ctrl+Enter+= Calculates the sheet
Ctrl+Enter+] Goes to Direct Dependant/s
Ctrl+Enter+' The cell above is copied; if a formula, it is as if absolute.
Ctrl+Enter+; m/d/y date
Ctrl+Enter+? Not sure yet!
Ctrl+Enter+w saves the activeworkbook
Ctrl+Enter+o Displays the Open File dialog box
Ctrl+Enter+p Print dialog box
Ctrl+Enter+a Select all cells
Ctrl+Enter+s Saves activeworkbook
Ctrl+Enter+f Displays Find dialog box
Ctrl+Enter+h Displays Find/Replace dialog box
Ctrl+Enter+g Displays GoTo dialog box
Ctrl+Enter+x Cuts cell
Ctrl+ Some actions are the same as Ctrl+Enter+
Ctrl+; Inserts current date
Ctrl+a Selects all cells
Ctrl+b bolds selection
Ctrl+c Activates copy mode
Ctrl+f Activates Find/Replace Dialog Box
Ctrl+g Activates GoTo Dialog Box
Ctrl+h Activates Find/Replace/Replace_All Dialog Box
Ctrl+i Italics selection
Ctrl+n Activates New Workbook Dialog Box
Ctrl+o Activates Open File Dialog Box
Ctrl+p Activates Print Dialog Box
Ctrl+s Saves workbook without prompting
Ctrl+u Underlines selection
Ctrl+v Pastes selection
Ctrl+w Closes current workbook with Prompt Message Box
Ctrl+x Activates cut mode
Other keyboard definitions
Ctrl+shift+: Inserts current time
shift+Ctrl+# Formats the cell as d-mm-yy
shift+Ctrl+= Displays Insert (rows/columns) dialog box
shift+Ctrl+1 Formats the cell as "General"
shift+Ctrl+4 Converts the cell to currency format
shift+Ctrl+6 Converts the cell to Exponential format
shift+Ctrl+7 Places a border around cell
shift+Ctrl+8 Selects CurrentRegion
shift+Ctrl+9 Unhides a row
shift+Ctrl+0 Unhides a column
shift+Ctrl+- Removes borders
Written by Mark Philpot - 27 April 2001