
File Menu
| Windows | Action | |
|---|---|---|
| Alt+F | Open File Menu | |
| Ctrl+N | New | |
| Ctrl+O | Open | |
| Ctrl+S | Save | |
| F3 | Save As | |
| Ctrl+P | ||
| Alt+F+G | Page SetUp | |
| Alt+F4 | Exit |
Edit Menu
| Windows | Action | |
|---|---|---|
| Alt+E | Open Edit Menu | |
| Ctrl+Z | Undo | |
| Ctrl+Shift+Z | Redo | |
| Ctrl+X/Shift+Del | Cut | |
| Ctrl+C/Ctrl+Insert | Copy | |
| Ctrl+V/Shift+Insert | Paste |
Text Formatting
| Windows | Action | |
|---|---|---|
| Ctrl+B | Bold | |
| Ctrl+I | Italic | |
| Ctrl+E | Align Center Text | |
| Ctrl+U | Underline | |
| Ctrl+L | Left Align Text | |
| Ctrl+R | Right Align Text | |
| Backspace | Erase Character from Left | |
| Spacebar | Enable/Disable Area within Cursor's Focus | |
| Ctrl+D | Insert Date | |
| Ctrl+Enter | Insert Hard Page Break | |
| Ctrl+Break | Terminate Execute Macro | |
| Delete | Erase Content from Cell/Selected Cells | |
| Tab | Move Right to Column | |
| Ctrl+Tab | Select Object in Chart | |
| Shift+Tab | Move Left One Cell | |
| Ctrl+Left Arrow | Move Left One Screen | |
| Ctrl+Right Arrow | Move Right One Screen | |
| Ctrl+Shift+F | Show SpeedFormat Dialog Box | |
| Ctrl+W | Show Symbols dialog Box | |
| Ctrl+F | Find and Replace | |
| Ctrl+Shift+S | Activate Styles List Box in Property Bar |
EditMode Shortcuts
| Windows | Action | |
|---|---|---|
| Esc | Exit Edit Mode | |
| Enter | Enters Data and Exit Edit Mode | |
| PgDn | Move Down One Screen | |
| PgUp | Move Up One Screen | |
| Insert | Toggle Insert and Overwrite Modes | |
| F2 | Toggle to Display Indicator on Application Bar | |
| Shift+F3 | Displays List of Macro commands | |
| Alt+F3 | Display List of SpreadSheet Functions | |
| F9 | Calculate and Display Formula Results on Input Line |
Object Keys
| Windows | Action | |
|---|---|---|
| Spacebar+Arrow Keys | Controls Pointer Movement When You draw an Object | |
| Spacebar+Home | Move Pointer Up and left Diagonally While Drawing | |
| Spacebar+PgUp | Move Pointer Up and Right Diagonally While Drawing | |
| Spacebar+End | Move Pointer Down and Left Diagonally While Drawing | |
| Spacebar+PgDn | Move Pointer Down and Right Diagonally While Drawing | |
| Ctrl+]/Ctrl+[ | Select Object First/Last Created on Active Spreadsheet | |
| F12 | Open Dialog Box specific to Object selected | |
| Esc | Close Current Dialog Box |
Formula Keys
| Windows | Action | |
|---|---|---|
| Ctrl++/Ctrl+- | Expand/Collapse Outline by One Level | |
| Ctrl+Shift+8 | Expand Whole Outline by Formula | |
| Ctrl+F | Go to Referenced Cell in Formula | |
| Ctrl+B | Returns to Previous Cell Containing Formula | |
| Ctrl+O | Replace Current Expression with an @Function | |
| Ctrl+P | Switch to Point Mode to specify A Cell Preference | |
| Ctrl+N | Replace Current Expression with Cell Name |
Print Preview
| Windows | Action | |
|---|---|---|
| F1 | Open Online Help | |
| Esc | Exit Preview | |
| +/- | Zoom in/Zoom out | |
| PgUp/PgDn | Show Previous/Next Spreadsheet |
Navigation
| Windows | Action | |
|---|---|---|
| Arrow Keys | Movement through cell | |
| F5/Ctrl+G | Move to Cell that You Specify |
Function Keys
| Windows | Action | |
|---|---|---|
| F1 | Open Help | |
| Ctrl+F1 | Open Writing Tools Dialog Box | |
| F2 | Activates Edit Mode | |
| Shift+F2 | Activate Debug Mode to Execute Macro | |
| Ctrl+F2 | Open Formula Composer Dialog Box | |
| Alt+F2 | Open Play Macro Dialog Box | |
| Shift+F3 | Shows List of Available Macros | |
| Alt+F3 | Display List of SpreadSheet Functions | |
| Ctrl+F3 | Create Named Cell or Cell Area | |
| Alt+F4 | Exit Quattro Pro | |
| Ctrl+F4 | Close window | |
| F5 | Open Go to Dialog Box | |
| Alt+F5 | Switch Group Mode On/Off | |
| F6 | Jump to Other Pane if window is Split | |
| F7 | Refresh Output of Previous Notebook Query | |
| F8 | Refresh Output of Previous What if Table | |
| Alt+F9 | Open Data Sort Dialog Box | |
| Ctrl+F8 | Separates Group into Individual Cells | |
| F10 | Move Selector to Menu Bar | |
| F11 | Display Current Chart | |
| F12 | Display Properties of Active Cell/Cells | |
| Alt+F11 | Open Visual Basic Editor | |
| Alt+F12 | Show Application Propertiess | |
| Ctrl+F12 | Show Properties of Current Spreadsheet |
Excel Compatibility Keys
| Windows | Action | |
|---|---|---|
| F7 | Open Writing Tools Dialog Box | |
| Ctrl+K | Open Edit Hyperlink Dialog Box | |
| Ctrl+H | Open Find/Replace Dialog Box | |
| Ctrl+1 | Open Format Selection Dialog Box | |
| Ctrl+R/Ctrl+D | Open QuickFill Dialog Box | |
| Alt+F8 | Open Play Macro Dialog Box |