Using shortcut keys

Quattro Pro can display keyboard shortcuts beside each menu command in the menu bar. You can disable this feature if you do not want shortcuts displayed.

You can customize many of the keyboard shortcuts. For more information about customizing keyboard shortcuts, see “Customizing keyboards.”

Depending on what mode you are in keyboard shortcuts may be repeated but their functions change.


Shortcuts for common tasks

Wordperfect Quattro Pro btnbacktotopproc Using shortcut keys

The following keys provide useful shortcuts for many tasks:

Key(s)
Description
Alt + (underscored letter)
Opens relevant menu. For example, pressing Alt + F opens the File menu.
underscored letter
Once a menu is open, press the underscored letter alone to select a command. For example, if the File menu is open, pressing P selects the Print command.
Alt, then Ctrl + Tab
Selects the first item on the first toolbar. Press Tab to move the focus to the right, press Shift + Tab to move it to the left, and press Spacebar to select an command. Press Ctrl + Tab again to move to the next toolbar.
Ctrl + N
File Wordperfect Quattro Pro onestep Using shortcut keys New
Ctrl + O
File Wordperfect Quattro Pro onestep Using shortcut keys Open
Ctrl + F4
File Wordperfect Quattro Pro onestep Using shortcut keys Close
Ctrl + S
File Wordperfect Quattro Pro onestep Using shortcut keys Save
F3
File Wordperfect Quattro Pro onestep Using shortcut keys Save as
Alt + F + G
File Wordperfect Quattro Pro onestep Using shortcut keys Page setup
Ctrl + P
File Wordperfect Quattro Pro onestep Using shortcut keys Print
Alt + F4
File Wordperfect Quattro Pro onestep Using shortcut keys Exit
Ctrl + Z
Edit Wordperfect Quattro Pro onestep Using shortcut keys Undo
Ctrl + Shift + Z
Edit Wordperfect Quattro Pro onestep Using shortcut keys Redo
Ctrl + X, or Shift + Del
Edit Wordperfect Quattro Pro onestep Using shortcut keys Cut
Ctrl + C, or Ctrl + Ins
Edit Wordperfect Quattro Pro onestep Using shortcut keys Copy
Ctrl + V, or Shift + Ins
Edit Wordperfect Quattro Pro onestep Using shortcut keys Paste
Ctrl + B
Makes selected text bold
Ctrl + I
Makes selected text italic
Ctrl + E
Centers selected text
Ctrl + U
Underlines selected text
Ctrl + L
Left aligns selected text
Ctrl + R
Right aligns selected text
Backspace
Erases the character to the left of the cursor when the cursor is in a cell.

Erases everything in a cell when the cell is selected.
Spacebar
Enables or disables the area within the cursor’s focus (such as check boxes or links in a list)
Caps lock
Enters Caps mode, in which all letters you type are displayed in uppercase letters. Press again to exit Caps mode
Ctrl + D
Inserts the date
Ctrl + Enter
Inserts a hard page break
Ctrl + Break
If pressed while a macro is executing, terminates the macro
Del
Erases the contents (but not properties) of the current cell or selected cells
Ctrl + Del
In Group mode, acts like Del, but “drills” the deletion through the group (deletes the selected cell, cells, or graphics on all grouped spreadsheets)
\ (Backslash)
Lets you type one or more characters to repeat across an entire cell width
Enter
In a notebook, writes the entry on the input line into the current cell, and returns to Ready mode. In a menu, choice list, or dialog box, chooses the selected item.
Esc
Cancels whatever task you are doing. For example, it can back you out of a menu, exit a dialog box, or erase any changes you made in the input line.
Num lock
Toggles performance of the numeric keypad keys between numeric keys and Arrow keys
Pause
Enters Macro Debug mode
Scroll lock
Toggles performance of the Arrow keys. When you first press Scroll lock, the SCRL indicator is enabled on the status bar and the Arrow keys scroll the contents of the active window without changing which cell is selected. When you press Scroll lock again, you can change which cell is selected with the Arrow keys.
Ctrl + Page down or Page up
In a notebook, moves from one spreadsheet to the next or previous spreadsheet. In a dialog box with multiple settings, changes panes (groups of property options).
Ctrl + Shift + Page down or Page up
Lets you selects multiple spreadsheets
Up or Down Arrow
In a dialog box text box, enters Point mode.
Tab
In a notebook, moves right one column. In a dialog box, moves between controls. In a Help window, use to move between jumps, and press Enter to select jumps.
Ctrl + Tab
In a graphics window, press Ctrl + Tab to select an object in the chart.
Shift + Tab
In a notebook, moves left one cell. In a dialog box, moves to the previous control. In a graphics window, moves to the beginning of the current word in a text box. Use Ctrl + Shift + Tab to select the previous item in a chart.
Ctrl + Left Arrow
In a notebook, moves left one screen
Ctrl + Right Arrow
In a notebook, moves right one screen
Ctrl + Shift + F
Displays the SpeedFormat dialog box
Ctrl + W
Displays the Symbols dialog box
Ctrl + Shift + L
Displays a list of series names from which you can choose to fill cells. Equivalent to clicking the QuickFill button on the notebook bar.
Ctrl + Shift + S
Activates the Styles list box on the property bar
Ctrl + Shift + N
Equivalent to clicking File Wordperfect Quattro Pro onestep Using shortcut keys New from template. Displays the PerfectExpert.
Alt + Down Arrow
In box, in a dialog box, with a Browse button, activates the Open File dialog box.
Ctrl + F
Opens the Find and replace dialog box


Edit mode keys

Wordperfect Quattro Pro btnbacktotopproc Using shortcut keys

The following keys are available in Edit mode.

Key(s)
Function
Esc
Exits Edit mode. If you click Tools Wordperfect Quattro Pro onestep Using shortcut keys Settings, and in the list of categories, double-click Workspace, Application and click General, and then enable the Compatible keys check box, pressing Esc erases the contents of the input line, and pressing Esc a second time exits Edit mode.
Enter
Enters the data and exits Edit mode
Ctrl + Enter
In Group mode, acts like Enter, but “drills” data through all grouped spreadsheets at once
Up Arrow
If data is wrapped on more than one line, moves the cursor up a line. If you click Tools Wordperfect Quattro Pro onestep Using shortcut keys Settings, and in the list of categories, double-click Workspace, Application and click General, and then enable the Compatible keys check box, pressing Up Arrow enters the data, exits Edit mode, and moves up one cell. When the cursor follows an operator in a formula, enters Point mode.
Down Arrow
If data is wrapped on more than one line, moves the cursor down a line. If you click Tools Wordperfect Quattro Pro onestep Using shortcut keys Settings, and in the list of categories, double-click Workspace, Application and click General, and then enable the Compatible keys check box, Down Arrow enters the data, exits Edit mode, and moves down one cell. When the cursor follows an operator in a formula, enters Point mode.
Page down
Enters the data, exits Edit mode, and moves down one screen. When the cursor follows an operator in a formula, enters Point mode.
Page up
Enters the data, exits Edit mode, and moves up one screen. When the cursor follows an operator in a formula, enters Point mode.
Ins
Toggles between Insert and Overwrite modes (Insert is the default)
Backspace
Deletes characters to the left of the cursor
Del
Deletes characters to the right of the cursor, selected cells, or a graphic
Ctrl + Backspace
Erases the contents of the input line
Ctrl + Right Arrow
Moves to the next page
Tab
Moves to the next cell. The cursor moves to the next page if you click Tools Wordperfect Quattro Pro onestep Using shortcut keys Settings, and in the list of categories, double-click Workspace, Application and click General, and then enable the Compatibility keys check box.
Shift + Tab
Moves to the previous cell
Ctrl + Left Arrow
Moves to the next page
Ctrl + Shift + Right Arrow
Selects content from the cursor to the next page.
Ctrl + Shift + Left Arrow
Selects content from the cursor to the previous page.
F2
Toggles to display an indicator on the application bar that tells you what type of data you are editingeither value or label
Shift + F3
Displays a list of macro commands
Alt + F3
Displays a list of spreadsheet functions
F9
Calculates and then displays formula results on the input line


Object keys

Wordperfect Quattro Pro btnbacktotopproc Using shortcut keys

The following list describes the shortcut keys available when working with objects, such as shapes, charts, and maps.

Key(s)
Description
Spacebar + Arrow keys
Controls horizontal and vertical pointer movement when you draw an object. If an object is selected, lets you control the object’s movement.
Spacebar + Home
Moves the pointer up and left diagonally when you draw an object. If an object is selected, moves the object up and left diagonally.
Spacebar + Page up
Moves the pointer up and right diagonally when you draw an object. If an object is selected, moves the object up and right diagonally.
Spacebar + End
Moves the pointer down and left diagonally when you draw an object. If an object is selected, moves the object down and left diagonally.
Spacebar + Page down
Moves the pointer down and right diagonally when you draw an object. If an object is selected, moves the object down and right diagonally.
Ctrl + ]
Selects the object that was created first on the active spreadsheet, and selects the remaining objects in the order in which they were created
Ctrl + [
Selects the object that was created last on the active spreadsheet, and selects the remaining objects in the reverse order in which they were created
F12
Opens a dialog box specific to the object selected
Esc
Closes the current dialog box. Also cancels the selection of a selected object.
Delete
Deletes the selected object


Formula Composer keys

Wordperfect Quattro Pro btnbacktotopproc Using shortcut keys

The following list describes the shortcut keys available when working in the formula outline pane of the Formula Composer.

Key(s)
Description
Ctrl + Plus sign
Expands the outline by one level
Ctrl + Shift + 8
Expands the whole outline for the formula
Ctrl + Minus sign
Collapses the current branch of the outline
Ctrl + F
Goes to a referenced cell in the formula
Ctrl + B
Returns to the previous cell containing a formula that references the current cell
Ctrl + E
Converts the current expression to a value
Ctrl + O
Replaces the current expression with an @function
Ctrl + P
Switches to Point mode to specify a cell reference by pointing to a cell (or cells) on a spreadsheet
Ctrl + N
Replaces the current expression with a cell name


Point mode keys

Wordperfect Quattro Pro btnbacktotopproc Using shortcut keys

The following keys are available in Point mode.

Key(s)
Function
Arrow keys + Period key
Press the Arrow keys to select the first cell and press the period key. Press the Arrow keys to move to the last cell you want to select.
Enter
Enters the selected cells in the formula or dialog box and, exits Point mode
Esc
If pressed while pointing to cells, returns you to the anchor cell
Backspace
If pressed while pointing to cells, returns you to the cell that was active before you entered Point mode
F4
Makes the cell address to the left of the cursor absolute. Press repeatedly to cycle through the absolute combinations; for example, $A:$B$4, $A:B$4. (Does not disturb the selected cell.)
Alt + F5
Turns Group mode on or off
F6
If the window is split into two panes, jumps to the other pane
Ctrl + F6
If multiple windows are open, jumps to the next window


Print preview keys

Wordperfect Quattro Pro btnbacktotopproc Using shortcut keys

The following table lists keys you can use while previewing.

Key
Effect
Esc
Exits the preview
F1
Displays online Help
Page up
Displays the previous spreadsheet
Page down
Displays the next spreadsheet
+ (plus key)
Zooms in a level, increasing detail
- (minus key)
Zooms out a level, decreasing detail
Up Arrow
Scrolls a zoomed display up
Down Arrow
Scrolls a zoomed display down
Right Arrow
Scrolls a zoomed display right
Left Arrow
Scrolls a zoomed display left
Home
Displays the top-left corner of a zoomed spreadsheet
End
Displays the bottom-right corner of a zoomed spreadsheet


Navigation keys

Wordperfect Quattro Pro btnbacktotopproc Using shortcut keys

The following keys let you move more easily through notebooks.

Key(s)
Description
Left Arrow
Moves left one cell
Right Arrow
Moves right one cell
Up Arrow
Moves up one cell
Down Arrow
Moves down one cell
Ctrl + Page down
Moves forward one spreadsheet
Ctrl + Page up
Moves backward one spreadsheet
Page up
Moves up one screen
Page down
Moves down one screen
Home
Moves to the upper-left cell (A1) of the active spreadsheet
Ctrl + Home
Moves to the upper- left cell (A1) of the first spreadsheet
End + Home
Moves to the lower-right corner of the filled part of a notebook
End + Arrow key
If the cursor is in a filled cell, the selector moves in the direction of the arrow to the next filled cell before an empty one
Tab
In a notebook, moves right one cell. In a dialog box, moves between controls. In a graphics window, inserts a tab space in text boxes. Press Ctrl + Tab to select the next graphic in a chart.
Shift + Tab
In a notebook, moves left one cell. In a dialog box, moves to the previous control. In a graphics window, moves to the beginning of the current word in a text box. Press Ctrl + Shift + Tab to select the previous graphic in a chart.
Ctrl + Left Arrow
Moves left one screen
Ctrl + Right Arrow
Moves right one screen
Ctrl + G, or F5
Moves to the cell you specify


Function keys

Wordperfect Quattro Pro btnbacktotopproc Using shortcut keys

The following list describes the use of each function key when pressed alone, and when pressed together with Ctrl, Shift, or Alt.

Key(s)
Description
F1
Opens Help
Shift + F1
Displays a question mark (?) and a pointer, so you can click a user interface element about which you want information. For example, if you click Shift + F1 and click a toolbar button, Help for that button displays.
Ctrl + F1
Opens the Writing tools dialog box and lets you check the spelling of a document.
F2
Activates Edit mode so you can change a cell entry
Shift + F2
Activates Debug mode so you can execute a macro step by step
Alt + F2
Displays the Play macro dialog box
Ctrl + F2
Opens the Formula composer dialog box
F3
When you are prompted for cells, or in Edit mode with the cursor positioned after an operator, displays a list of cell names. To expand the list to show cell coordinates, press + (plus sign). Press - (minus sign) to remove coordinates. Press F3 again to “zoom” the names list to the full screen.
Shift + F3
Displays a list of available macros, by category
Alt + F3
In Value or Edit mode, displays a list of spreadsheet functions, by category
Ctrl + F3
Lets you create a named cell or cell area
F4
In Edit, Value, or Point mode, makes the cell address to the left of the cursor absolute. Press repeatedly to cycle through the eight absolute combinations; for example, $A:$B$4, $A:B$4. You can use F4 when typing or editing a formula.
Alt + F4
Exits Quattro Pro
Ctrl + F4
Closes a window (notebook, dialog box, graphics window, light table window, or dialog window)
F5 or Ctrl + G
Opens the Go to dialog box
Shift + F5
Works like the Quick tab button next to the spreadsheet tabs ; displays the Objects spreadsheet, and then returns to a spreadsheet
Alt + F5
Switches Group mode on and off
F6
If the window is split into two panes, jumps to the other pane
Shift + F6
Displays the previous open window
Ctrl + F6
Displays the next open window
F7
Refreshes output of the previous Notebook query
Shift + F7
In Edit mode, lets you use the Arrow keys to select cells containing text
F8
Refreshes output of the previous What-If tables
Shift + F8
Combines selected cells into a group
Ctrl + F8
Separates a group into individual cells
F9
In Ready mode, recalculates the formulas in a notebook. In Edit mode, calculates and displays on the input line the results of formulas. For example, if you type 8*9 on the input line, and press F9, the formula is replaced with the result, 72. To recalculate the entire notebook afterwards, press F9 again in Ready mode.
Shift + F9
Expands the details of a currently collapsed outline group
Alt + F9
Opens the Data sort dialog box
Ctrl + F9
Collapses the details of a currently expanded outline group
F10
Works like / or Alt; moves the selector to the me
nu bar.
Shift + F10
Provides a shortcut to the right-click menu
F11
Displays the current chart
Alt + F11
Opens the Visual Basic Editor
F12
Displays the properties for the active cell or cells
Shift + F12
Displays the properties for the active window or notebook
Alt + F12
Displays the properties for the application
Ctrl + F12
Displays the properties of the active spreadsheet


CrossTab report keys

Wordperfect Quattro Pro btnbacktotopproc Using shortcut keys

The following shortcut keys can be used in the CrossTab report dialog box when creating a CrossTab report.

Keys
Description
Tab
Lets you move between different areas of the CrossTab report dialog box
Arrow keys
Let you move between the different options in an area of the CrossTab report dialog box.
Ctrl+P
Places the selected field in the Pages section of the layout.
Ctrl+C
Places the selected field in the Columns section of the layout.
Ctrl+R
Places the selected field in the Rows section of the layout.
Ctrl+D
Places the selected field in the Data section of the layout.
Ctrl+F or Delete
Places the selected field from a section in the layout back in the Fields list.
Alt+F
Selects the Fields list.


Excel compatibility keys

Wordperfect Quattro Pro btnbacktotopproc Using shortcut keys

The following keys are active only when the Microsoft Excel menu is displayed.

Key(s)
Description
F7
Opens the Writing tools dialog box and lets you check the spelling in a spreadsheet
Ctrl + K
Opens the Edit hyperlink dialog box
Ctrl + H
Opens the Find/replace dialog box
Ctrl + R, or Ctrl + D
Opens the QuickFill dialog box
Alt + F8
Opens the Play macro dialog box
Ctrl + 1
Opens the Format selection dialog box

Using shortcut keys