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 |
|
|
---|---|
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 |