Before beginning your project, you should familiarize yourself with the concepts and desktop components that will help you create spreadsheet-based documents. Quattro Pro features many tools which provide you with tools that give you quick access to your data to increase your efficiency. You can also customize your workspace and tailor your toolbars to present a familiar working environment each time you launch your application.
In this section, you'll learn about
components of a notebook
working with Quattro Pro Experts
working with toolbars
working with the application bar
navigating in spreadsheets and notebooks
selecting cells, rows, and columns
inserting and deleting cells, rows, and columns
adding, deleting, moving, and copying spreadsheets
naming spreadsheets
specifying Quattro Pro settings
displaying, arranging, resizing, and hiding windows
zooming data and hiding and displaying screen components
customizing menus
customizing keyboards
saving a notebook group
setting multiple workspaces
saving and closing notebooks
For more information about getting started, see "Reference: Getting started."
Components of a notebook
Notebooks, spreadsheets, and their associated elements are the core of the Quattro Pro application. Notebooks provide a way to organize many spreadsheets within the same file. There are 18,000 spreadsheets in a notebook. Each spreadsheet consists of approximately 1,000,000 rows and 18,000 columns.
Outline of notebook components
The following information describes the basic components of a Quattro Pro notebook.
Spreadsheets
A spreadsheet is an electronic ledger. It contains columns and rows in which you enter, arrange, calculate, and analyze data. In a spreadsheet, you can arrange and categorize data, perform simple math operations, and apply complex formulas. Once you enter your data in a spreadsheet, you can create a chart, add maps and graphics, or produce a report. The spreadsheet you see when Quattro Pro opens is one of thousands available in each notebook.
Objects sheet
The last sheet of every notebook is the Objects sheet. The Objects sheet displays an icon for every chart in the notebook. This sheet also displays icons for custom dialog boxes you build. You can copy, rename, and print items in the Objects sheet. The Objects sheet property bar has buttons for creating, editing, and displaying charts and for building custom dialog boxes.
Project templates
Project templates let you create a new notebook based on a pre-designed project. Many of the Quattro Pro project templates provide a basic format and structure for common spreadsheets and data entry forms. You can also create your own project templates.
Values
A value is a number, date, formula, or the result of a formula. Quattro Pro automatically determines whether data is a value or a label. As you type your data in a cell, the READY indicator on the application bar changes to LABEL or VALUE, depending on the type of data you enter.
Labels
Labels contain alphanumeric data, such as titles, phone numbers, or addresses. Quattro Pro interprets and formats labels differently than it does values. Values are calculable; labels are not.
Formulas
Formulas are mathematical equations. Formulas usually refer to numbers in other cells in order to calculate a value, such as the difference between the values in two cells or the total of values in a column. You can use mathematical functions and numbers in formulas.
Spreadsheet functions
Spreadsheet functions are built-in formulas that automate many of the calculations you perform in a spreadsheet. For example, @AMAINT is a spreadsheet function that calculates the accumulated interest paid on a loan after a specified number of payments. All spreadsheet functions are preceded by an @ sign.
Macros
Macros are computer scripts that automate complex or repetitive command sequences. A macro is a sequence of commands that Quattro Pro runs automatically. Macros can perform keystrokes, mouse actions, and menu commands. You can use macros to automate tasks (such as printing a standard report), enter frequently used labels with a keystroke, or build complete applications to simplify Quattro Pro tasks for other users.
Working with Quattro Pro Experts
Quattro Pro Experts guide you step by step through many spreadsheet tasks. You can access Quattro Pro Experts from a toolbar or from a menu. The following Experts are available:
PerfectExpert-helps you quickly perform many common Quattro Pro tasks
Analysis Expert-helps you make many analysis calculations, such as advanced regression, correlation, covariance, exponential smoothing, F-test, moving average, sampling, T-test, and Z-test
Budget Expert-guides you in creating five different budget templates for both home and business use
Consolidate Expert-lets you combine cells using statistical operators (SUM, AVG, COUNT, MIN, MAX, STD, STDS, VAR, VARS), after which you can sort the combined data
External Data Expert-lets you easily import data from a database, such as a Paradox or dBASE database. It also supports Query By Example (QBE) and Open Database Connectivity (ODBC).
Map Expert-builds a map from selected cells of data
Scenario Expert-lets you create and display groups of scenarios (data conditions and results) based on models in your notebook.
What-If Expert-lets you create tables that show the effect of changing one or two variable cells referenced in a formula
To access an Expert from a toolbar
1 Right-click a toolbar, and click Experts and numeric tools.
2 From the Experts and numeric tools toolbar, click the Expert you wish to use.
Tip
You can point to a toolbar button to see a description of a particular Expert.
To access an Expert from a menu
Follow the menu path in the table below to access a particular Expert.
Toolbars give you quick access to the features you frequently use. You can create your own toolbars from a wide assortment of toolbar buttons. Quattro Pro creates a personal toolbar to which you can drag or copy toolbar buttons.
You can edit a toolbar to display the buttons you want, and in the order you want them. Because of the enhanced toolbar functionality in Quattro Pro, you cannot use toolbars that you created in earlier versions of Quattro Pro. These toolbars must be re-created. However, you can import toolbars that other people have created in Quattro Pro by using the workspace feature.
You can display toolbars horizontally or vertically around the Quattro Pro window, or display a floating toolbar within the spreadsheet window. You can hide any toolbar you don't want displayed. The following standard toolbars come with Quattro Pro:
Notebook-provides tools for entering and editing data
Selection formatting-provides tools for manipulating the current selection
Data manipulation-provides tools for working with notebook cells and selections
Drawing tools-provides tools for drawing or inserting objects in a graphics window, and for arranging objects on a layer on top of the notebook
Outlining tools-provides tools for grouping data in collapsible and expandable sets of information
Auditing tools-provides tools for tracing dependent cells, precedents, and even errors in large, complex notebooks
Review-provides tools for reviewing shared notebooks
Experts and numeric tools-provides tools for quickly creating maps, charts, and budgets, and for performing computations
CrossTab report-provides tools for manipulating cross-tab reports
Visual Basic-launches the Visual Basic Editor and Visual Basic Design Mode
You can reposition a toolbar by dragging it to the top, bottom, left, or right edge of the application window. If you drag the toolbar away from all edges of the application window, it becomes a floating toolbar. You can also rename or delete a toolbar you have created. If you make changes you no longer want, you can reset the toolbar to its default settings.
You can change the graphic or text of a toolbar button, or have Quattro Pro display text under all toolbar buttons.
Quattro Pro lets you create a button that will launch a Windows application or document. You can also create a button that executes either a Quattro Pro or PerfectScript macro.
To create a toolbar
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Toolbar.
4 Click New.
5 Type a name for the toolbar.
6 Click Commands.
7 Choose the commands you want from the Commands list.
Each command appears under the appropriate menu name.
8 Drag the commands from the list to the toolbar.
To edit a toolbar
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Toolbar.
4 Enable the check box beside the toolbar you want to customize.
5 Click Commands.
6 Choose the command you want from the Commands list.
Each command appears under the appropriate menu name.
7 Drag the command to the desired location on the toolbar.
You can also
Rearrange toolbar buttons Click Commands, and drag the toolbar buttons to their new locations
Resize toolbar buttons Click Toolbar, and change the Button and Border settings
Delete toolbar buttons Click Commands, and drag the toolbar buttons off the toolbar
Add a separator between toolbar buttons Click Commands, select User menus from the list box, and drag the separator to a toolbar
Tip
If you want to customize a context menu, select Context menu from the toolbar list.
To display a toolbar
1 Right-click any toolbar.
2 Click the toolbar you want to display.
To move a toolbar
1 Point to the two vertical gray lines at the left of a toolbar.
2 Drag the toolbar to a new position.
Tip
To have a toolbar title display on a floating toolbar, enable the Show title when toolbar is floating check box in the toolbar customization dialog box.
To rename a toolbar
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Toolbar.
4 Select a toolbar.
5 Press F2.
6 Type a new name.
Note
You cannot rename system-defined toolbars.
To delete a toolbar
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Toolbar.
4 Select a toolbar.
5 Click Delete.
Note
You cannot delete system-defined toolbars.
To reset a toolbar
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Toolbar.
4 Select a toolbar.
5 Click Reset.
Note
You can only reset a system-defined toolbar.
To display a graphic or text on a toolbar button
1 Right-click a button on a toolbar, and click Customize Toolbar item.
2 Enable one of the following display options:
Image only
Caption only
Caption below image
Caption to right of image
Tip
You can revert the toolbar button to its original display setting by right-clicking the button, and clicking Customize Toolbar item Default.
To display text under all toolbar buttons
Right-click a button on a toolbar, and click Customize Notebook toolbar Caption below image.
To add a toolbar button that launches an application or document
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Commands, and choose Programs from the list box.
4 Click the Program command category tab.
5 Click Add.
6 In the Target list box, choose the file or application for which you want to create a button.
7 In the Parameters list box, specify any command line options.
8 In the Working folder list box, specify the working directory.
Leave the Working folder list box blank if you want to use the Quattro Pro startup folder.
9 Click Apply, and drag the new button to a toolbar.
Tips
You can change the appearance and associated tooltip for the new button by clicking the Appearance and General tabs.
You can delete a toolbar button by selecting the command from the list and clicking Remove.
To add a toolbar button that plays a macro
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Commands, and choose Macros from the list box.
4 Click the Macro command category tab.
5 Click Add.
6 Click one of the following buttons:
Quattro Pro macro, and type the macro command in the Enter macro box.
PerfectScript macro, and specify the macro file (.wcm).
7 Click Apply, and drag the new button to a toolbar.
Note
For more information about macros and toolbar buttons, see "To attach a macro to a toolbar button."
Tips
You can change the appearance and associated tooltip for the new button by clicking the Appearance and General tabs.
You can delete a toolbar button by selecting the command from the list and clicking Remove.
Working with the application bar
The application bar displays mode and status indicators. For example, if you press Caps lock, the application bar display shows that Caps lock is on. You can customize the application bar to record and maintain your personal preferences.
The application bar is usually located at the bottom of the Quattro Pro desktop. However, you can change the position of the application bar. You can also change the height of the application bar.
The QuickCell feature is also displayed on the application bar. With QuickCell, you can view a selected cell on the application bar to see its updated value as you change other cells elsewhere in the spreadsheet.
To customize the application bar
1 Right-click the application bar, and click Customize Application bar Add new command.
2 Select View from the Commands list box.
3 Select a command from the list.
4 Drag the command to the desired position on the application bar.
You can also
Reset the application bar to its original state Right-click the application bar, and click Customize Application bar Reset to default
Add spaces to the application bar Right-click the application bar where you want to place a separator, and click Customize Application bar Add separator
Tip
You can move commands and spaces in the application bar without opening the Customize dialog box by holding down Alt as you drag.
To change the position of the application bar
1 Right-click the application bar, and click Customize Application bar Position.
2 Click Top or Bottom.
To change the height of the application bar
1 Right-click the application bar, and click Customize Application bar Size.
2 Click One line or Two lines.
Tip
You can also change the height of the application bar by dragging its border.
To use the QuickCell feature
1 Click a cell on the spreadsheet.
2 On the application bar, click QuickCell.
You can also
Clear the QuickCell value Click a blank cell on the spreadsheet, and click QuickCell
Disable QuickCell Right-click the application bar, click Customize Application bar Add new command, and drag the QuickCell button from the application bar to the spreadsheet window
Navigating in spreadsheets and notebooks
You can navigate columns and rows on a spreadsheet using the arrow keys, the Enter key, and the Tab key. You can also automatically scroll through a spreadsheet using the AutoScroll tool. As well, you can quickly navigate to the Objects sheet, and cycle through open notebooks.
Menu and dialog box options can be accessed using the keyboard. For a complete list of keyboard shortcuts, see Quattro Pro keyboard shortcuts in the reference information section of the Quattro Pro online help.
Finally, you can go directly to specific cells or data types using the Go To and Browse By features.
To navigate in a spreadsheet
Press the relevant key, as outlined in the table below.
To Do the following
Move down columns after entering data Press Enter or the Down arrow
Move up columns after entering data Press the Up arrow
Move across rows after entering data Press the Left arrow or Right arrow
Note
The Enter key can be used to move the selector in a direction other than down. For more information see "To set the selector to move when you press Enter."
Tip
You can also move across rows by pressing the Tab key.
To automatically scroll through a spreadsheet
1 On the notebook toolbar, click AutoScroll.
The cursor changes to the AutoScroll arrow.
2 Move the AutoScroll arrow in the direction you want to scroll.
Tips
The scrolling speed increases as you move the arrow farther away from the AutoScroll tool.
You can disable AutoScroll by clicking anywhere on the spreadsheet.
To go to the Objects sheet
Click the Quick tab button at the bottom left of the notebook window.
Tip
To return to the original spreadsheet, click the Quick tab button again.
To cycle through open notebooks
On the application bar, click the button that displays the notebook's name.
Tips
You can also move through open notebooks by pressing Shift + F6 to cycle forward or Ctrl + F6 to cycle backwards.
If the displayed notebook title begins with a directory path, you can click Tools Settings File options, and disable the Enable full path titles check box. This will allow you to display notebook titles without the full directory path.
To access menu options using the keyboard
1 Press and hold down the Alt key.
2 Type the underlined letter for the menu you want to open.
3 Use the arrow keys to move from menu to menu, and from option to option.
4 Press Enter to choose a highlighted option.
Note
For a list of keyboard shortcuts, see Quattro Pro keyboard shortcuts in the reference information section of the Quattro Pro online help.
Tip
You can press the Esc key to return to the spreadsheet without making a menu selection.
To access dialog box options using the keyboard
Press the relevant key combination as outlined in the table below.
To Do the following
Select options Hold down Alt and type the underlined letter for the option you want
Move from option to option Press Tab
Enable/disable buttons and check boxes Press the Spacebar
Select text boxes Press Tab, and type information into the boxes
Select pop-up lists Press Tab, and press the Spacebar to open the lists
Select buttons Press Tab, and press Enter to activate the buttons
Note
For a list of keyboard shortcuts, see Quattro Pro keyboard shortcuts in the reference information section of the Quattro Pro online help.
To go to a specific cell in a notebook
1 Click Edit Go to.
2 Type the cell address in the Reference box.
If the cell is on another spreadsheet, include the spreadsheet name in the address. For example, to move to cell Z36 on spreadsheet D, type D:Z36. If the cell is in another notebook, add the notebook prefix, for example, [Budget]D:Z36.
You can also
Go to a named cell Choose the cell or group name from the Names box
Go to a named spreadsheet in the current notebook Choose the spreadsheet name from the Sheets box
Go to the most recently edited cells Choose a cell location from the Last edited box
Go to a cell type Choose a cell type from the Other box
To browse to specific data in a notebook
1 Right-click the Browse By button in the lower-right corner of the spreadsheet.
2 Choose a data type.
Selecting cells, rows, and columns
You can select cells individually or in rows, columns, blocks, or 3-D blocks. When you select a cell, a black-bordered rectangle displays to indicate the active cell. This rectangle is called the selector. You can set the selector to move when you press the Enter key.
You can select noncontiguous cells, allowing you to write formulas that refer to various selections in different locations. You can also select a 3-D block of cells, which is a group of cells selected on more than one spreadsheet. For example, A2..B5 on sheets A through D is a 3-D selection. The syntax for 3-D selections can also be changed to suit your specific needs.
When you need to enter cell references in dialog boxes, it is usually easier to select the cells rather than type the entire cell address. Quattro Pro lets you use the Range picker to easily select cells.
SpeedSelect lets you quickly select an entire block of cells. As well, you can use the SpeedSelect buttons to quickly move to each corner of the block.
You can select entire rows, columns, and spreadsheets. You can also select multiple spreadsheets.
You can lock specific rows and columns of a spreadsheet so that their titles remain on the screen as you scroll. A blue line divides the locked area and the notebook data. Locked titles do not affect printing. You can also repeat column titles on each spreadsheet of a printed notebook.
To set the selector to move when you press Enter
1 Click Tools Settings.
2 Click General.
3 Disable the Compatibility keys check box.
4 Enable the Move cell selector/enter key check box.
5 From the list box, choose Down, Up, Left, or Right depending on the direction you want the selector to move when you press Enter.
To select noncontiguous cells
1 Select the first group of cells.
2 Hold down Ctrl, and select additional cells.
Note
If you want to type references to noncontiguous selections in a formula, separate each selection with a comma, as shown in this example: A2..A5,B7,D5..E12.
To select a 3-D block of cells
1 Select the cells on the first spreadsheet.
2 Hold down Shift and click the tab for the last spreadsheet in the series.
A black line appears under the tabs; the same cells are now selected on all the sheets where the black line appears.
Notes
The cells remain selected only until you click elsewhere in the notebook.
If you want to type a reference to a 3-D block, include the spreadsheet references first, followed by the cell coordinates.
To change 3-D spreadsheet range syntax
1 Click Tools Settings.
2 Click Compatibility.
3 In the 3-D syntax area, click one of the following options:
A..B:A1..B2-expresses spreadsheet references first, followed by a colon and the cell coordinates. This syntax makes group references more concise.
A:A1..B:B2-refers to each corner of the 3-D selection with the spreadsheet reference included
Note
When you click a new cell, all existing 3-D references in formulas in open notebooks switch to the new syntax.
To select cells from a dialog box
1 Click the Range picker.
2 Select the cells you want to appear in the edit field of the dialog box.
3 Maximize the dialog box.
Tip
You can also select cells by double-clicking the contents of the edit field.
To quickly select data on a spreadsheet
1 Select one cell within a block of cells.
2 Right-click a toolbar, and click Data manipulation.
3 On the Data manipulation toolbar, click Select table.
All the cells are selected.
To quickly move to a corner of a block of cells
1 Select one cell within a block of cells.
2 Right-click a toolbar, and click Data manipulation.
3 Click one of the following navigation tools:
-Top left of table button
-Top right of table button
-Bottom left of table button
-Bottom right of table button
To select a row or column
Select the row or column heading.
To select multiple spreadsheets
1 Click the tab of the first spreadsheet to select.
2 Hold down Shift while you click the last spreadsheet tab you want included in the selection.
A black line appears under the tabs.
To lock titles on a spreadsheet
1 Select the top-left cell of the spreadsheet area you want to remain scrollable.
2 Click View Locked titles.
A blue line divides the locked area and the notebook data.
Note
The Locked titles option is only available in Draft view.
Tips
You can display only row titles or only column titles as locked titles by selecting the row or column below or to the right of the last one to be displayed.
To unlock titles, click View Locked titles again.
To repeat column titles on each spreadsheet of a printed notebook
1 Click File Page setup.
2 Click the Options tab.
3 Type the location of the column title in the Top heading box.
Tip
You can also repeat row titles by typing the location of the row title in the Left heading box.
Inserting and deleting cells, rows, and columns
You can insert cells, rows, or columns anywhere in a spreadsheet. When you insert an item, existing data is pushed down, to the right, or to the back of the notebook to make room for the new item.
You can also copy and insert data and cells. When you copy and insert data and cells, Quattro Pro inserts the correct number of cells for the copied data, and pastes the data in the spreadsheet. For more information about copying cells, see "Moving cells, rows, and columns."
When data is no longer useful, you can easily delete cells, rows, columns, or multiple rows and columns.
You can prevent other users from adding rows and columns to a spreadsheet by entering data in the last cell of the spreadsheet. Since this cell can't be pushed down or to the right, no extra cells can be added to the spreadsheet.
To insert a cell
1 Select a cell in the location where you want to insert a new cell.
2 Click Insert Insert cells.
3 Enable the Partial option in the Span area.
4 Enable one of the following options in the Dimension area:
Rows-the selected cell will shift down and out of the way
Columns- the selected cell will shift to the right
Sheets-the selected cell will shift to the next spreadsheet
Note
You can also insert the correct number of cells for data that you copy. For more information, see "To copy and insert data and cells
Tip
You can also insert multiple cells. Make sure the upper-left corner of the cells you select contains the first cell entry you want shifted right, down, or back. The cells you select should be the same size as the amount of space you want to insert.
To insert a row
1 Select the row heading just below where you want the row inserted.
2 Click Insert Insert row.
Notes
When you insert a row within the boundaries of a named area or a cell referenced by a formula, the cell references expand to include the new row.
You can also insert the correct number of cells for a row of data that you copy. For more information, see "To copy and insert data and cells."
Tip
You can insert multiple rows by selecting multiple row headings, and clicking Insert Insert row.
To insert a column
1 Select the column heading to the right of where you want the column inserted.
2 Click Insert Insert column.
Notes
When you insert a column within the boundaries of a named area or a cell referenced by a formula, the cell references expand to include the new column.
You can also insert the correct number of cells for a column of data that you copy. For more information, see "To copy and insert data and cells."
Tip
You can insert multiple columns by selecting multiple columns headings, then clicking Insert Insert column.
To copy and insert data and cells
1 Select the row, column, or block of cells that contains the data you want to copy.
2 Click Edit Copy.
3 Select the upper left-most cell where you want to insert the copied data and cells.
4 Right-click, and click QuickPaste.
5 In the Dimension area, enable one of the following options:
Rows-to shift cells down and out of the way
Columns-to shift cells to the right
6 In the Span area, enable one of the following options:
Entire-to insert an entire row or column
Span-to insert the required cells in a row or column
To delete a cell
1 Select the cell you want to delete.
2 Click Edit Delete cells.
3 Enable the Partial option in the Span area.
4 Enable one of the following options in the Dimension area:
Rows-the cell below the selected cell will shift up
Columns-the cell to the right of the selected cell will shift to the left
Sheets-the corresponding cell on the next spreadsheet will shift to the current spreadsheet
Tip
You can also delete multiple cells by first selecting a block of cells.
To delete a row or a column
1 Select the row or column heading.
2 Click Edit Delete cells.
Tip
You can delete multiple rows or columns by selecting multiple headings, and clicking Edit Delete cells.
To restrict the addition of rows and columns
1 Press End, and press the Down arrow.
2 Press End, and press the Right arrow.
The cursor is at the last cell in the spreadsheet.
3 Type any label or value.
4 Press Home to get back to the first cell in the spreadsheet.
When you try to add a row or column, an out of boundary message displays.
Note
If the spreadsheet contains data, pressing End and then the Down arrow and Right arrow keys moves the cursor to the last cell of the block. Keep pressing this combination to move to the last cell in the spreadsheet.
Adding, deleting, moving, and copying spreadsheets
You can add or delete single or multiple spreadsheets to or from your notebook. You can move sheets within a notebook or between notebooks to reorder them, using the mouse to drag the spreadsheet tab to another location. In the same way, you can also copy spreadsheets within a notebook.
To insert a spreadsheet
1 Click the tab of the spreadsheet you want to follow the new spreadsheet.
2 Click Insert Insert sheet.
To insert multiple spreadsheets
1 Click Insert Insert cells.
2 Enable the Sheets option in the Dimension area.
3 Enable the Entire option in the Span area.
4 Type a 3-D selection in the Cells field.
For example, to insert three sheets before spreadsheet B, enter B:A3..D:A3 (it does not matter which cell you reference).
To delete a spreadsheet
1 Click a spreadsheet tab.
2 Click Edit Delete cells.
3 Enable the Sheets option.
4 Enable the Entire option.
Tip
You can also delete a spreadsheet by right-clicking a spreadsheet tab, and clicking Delete sheet.
To delete multiple spreadsheets
1 Click the first spreadsheet tab.
2 Hold down Shift while you click the last spreadsheet tab to delete.
A black line appears under the tabs.
3 Click Edit Delete cells.
4 Enable the Sheets option.
5 Enable the Entire option.
To move a spreadsheet
1 Click the tab of the spreadsheet you want to move.
2 Drag the spreadsheet tab in any direction until a sheet icon appears.
3 Move the sheet icon by dragging right or left along the row of tabs.
4 Release the mouse button when the sheet icon is where you want to place the spreadsheet.
Note
You can also move a spreadsheet by clicking Edit Move Sheets, and specifying the sheets to move.
To copy a spreadsheet
1 Hold down Ctrl and click the tab of the spreadsheet you want to copy.
2 Drag the spreadsheet tab in any direction until a sheet icon appears.
3 Move the sheet icon by dragging right or left along the row of tabs.
4 Release the mouse button when the sheet icon is where you want to place the spreadsheet.
Tip
You can also copy a spreadsheet by clicking Edit Select all, and then clicking Edit Copy.
Naming spreadsheets
Each spreadsheet in a notebook has a tab at the bottom. This tab displays the name of the spreadsheet. Spreadsheets are initially named with letters of the alphabet in sequence, from A to Z, continuing from AA to AZ, up to ZZZ. You can assign a descriptive name to a spreadsheet using up to 64 characters (letters and numbers).
You can also change the spreadsheet name to reflect the naming conventions used by applications such as Microsoft Excel.
To rename a spreadsheet
1 Click Format Sheet properties.
2 Click the Name tab.
3 Type a descriptive name.
Notes
The Objects sheet (the last sheet in the notebook) cannot be renamed.
When you rename a spreadsheet, formulas that refer to the renamed spreadsheet adjust to use the new name.
Tips
To reassign the original name to a spreadsheet, click Reset.
You can also name a spreadsheet by double-clicking its tab.
To rename a spreadsheet using Microsoft Excel conventions
1 Click Tools Settings.
2 Click Compatibility.
3 Enable the Display as numbers check box.
Note
To change spreadsheet tabs back to letters, disable the Display as numbers check box.
Specifying Quattro Pro settings
Application settings affect the overall functioning of Quattro Pro. Changes you make to these settings remain in effect until you change them again, even after you exit and restart Quattro Pro. Property settings allow you to see at a glance all changes that can be made to individual items in the notebook.
You can view statistical information about a Quattro Pro notebook. This includes the filename, directory path, date it was created, date it was last saved and by whom, and the revision number.
The notebook summary feature lets you record information, such as a file's title, subject, author, and keywords. You can also record comments pertaining to the file. Summary information is useful when searching for a file using QuickFinder. If you publish a notebook to the Internet, the summary information is transferred to the corresponding fields in your Web document.
You can create or edit notebooks in a format compatible with other programs by changing Quattro Pro compatibility options. Changes can be made to the default file save and file open types, as well as to notebook sizes. These changes become the program's default settings.
You can change international settings for currency and punctuation from within Quattro Pro. You can also change date, and time formats in individual cells. In addition, you can convert LICS characters.
Finally, the Quattro Pro language option allows you to have your interface display in the language you select from a list of languages. You must have another language version installed to be able to change the interface language.
To change application settings
Click Tools Settings.
To change the properties of an item
You can change the properties of an item by clicking the following menu items:
Menu item Properties
Format Selection properties Active cell properties
Format Sheet properties Active sheet properties
Format Notebook properties Active notebook properties
Tip
You can also change properties by right-clicking an item, and selecting Selection properties.
To view statistics on a notebook
1 Click File Properties.
2 Click the Statistics tab.
Tip
You can also access the Statistics and Summary tabs by clicking Format Notebook properties.
To record summary information about a notebook
1 Click File Properties.
2 Click the Summary tab.
3 Record the appropriate information in any of the following boxes:
Title
Subject
Author
Keywords
Comments
Tip
You can also access the Statistics and Summary tabs by clicking Format Notebook properties.
To change compatibility options
1 Click Tools Settings.
2 Click Compatibility.
To change the default file save type
1 Click Tools Settings.
2 Click Compatibility.
3 Choose a file extension from the Default file type list.
To change the default file open type
1 Click Tools Settings.
2 Click Compatibility.
3 Choose a file extension from the Default open file types list.
To change the notebook size
1 Click Tools Settings.
2 Click Compatibility.
3 Type the number of sheets you want in the Sheets box.
4 Type the number of columns you want in the Columns box.
5 Type the number of rows you want in the Rows box.
Note
You can also set the syntax for 3-D blocks. For more information, see "To change 3-D spreadsheet range syntax."
To change the currency symbol
1 Click Tools Settings.
2 Click International.
3 Enable the Currency option.
4 Enable the Quattro Pro option, and click the country whose currency symbol you want to use.
5 Enable one of the following options:
Signed-precedes negative values with a minus sign
Parens-encloses negative values in parentheses
Notes
When you change the currency symbol, it becomes the default currency. To show multiple currencies in one notebook, change the currency of individual cells with Format Selection properties Numeric format Currency. This lets you use multiple currencies in one notebook.
Quattro Pro has added the Euro to the available currency formats. You can view the Euro currency symbol if you are using Microsoft Windows 98 or if your system has a Euro compliant font installed.
To change punctuation settings
1 Click Tools Settings.
2 Click International.
3 Enable the Punctuation option.
4 Select a punctuation option.
The options show the punctuation marks used to mark thousands and the decimal place, followed by the punctuation mark used to separate arguments in spreadsheet functions and macros (a1,a2). The last four options specify that a blank space in numbers separates thousands.
To change available date formats
1 Click Tools Settings.
2 Click International.
3 Enable the Date format option.
4 Select a date format option.
Note
For more information about date formats, see "To format dates and times."
Tip
This date format does not determine how dates appear. Rather, it determines the international date formats given as options for date appearance. To set the actual appearance of dates, click Format Selection properties, and click the Numeric format tab.
To change available time formats
1 Click Tools Settings.
2 Click International.
3 Enable the Time format option.
4 Select a time format option.
Note
For more information about time formats, see "To format dates and times."
Tip
This time format does not determine how times appear. Rather, it determines the international time formats given as options for time display. To set the actual appearance of times, click Format Selection properties, and click the Numeric format tab.
To convert LICS characters
1 Click Tools Settings.
2 Click International.
3 Enable the LICS check box.
Note
Lotus International Character Set (LICS) characters are identical to the standard ANSI set except for the range 128 through 255, which is usually used for international and graphics characters. For more information about LICS characters, see your Lotus 1-2-3 documentation. When you save the notebook, these characters are converted back to the LICS equivalents.
To change the default language
1 Click Tools Settings.
2 Click International.
3 Enable the Language option.
4 Enable one of the following options:
Suite default-specifies the default language of all suite applications
Quattro Pro-specifies a different language for only Quattro Pro
Displaying, arranging, resizing, and hiding windows
A Quattro Pro window displays a Quattro Pro file, or a file imported into Quattro Pro. While working in Quattro Pro, you can have several windows open. For example, suppose you are working with four different notebooks, each dealing with a quarterly report. You can display all four at once.
You can select which windows you want open, and how you want to view the data in those windows. As well, there are several methods of rearranging windows on your desktop. You can also hide windows.
You can change how you view your notebook without changing the notebook itself. For example, you can use Draft view when quickly entering data, or you can use Page view when you want to change margins and see how information will fit on a printed page. You can also use Zoom to make the notebook display larger or smaller.
You can display actual formulas instead of formula results. You can also have Quattro Pro automatically display spreadsheet comments. Once a comment is displayed, you can move or copy it to a new cell.
You can create any number of views. When you create a new view of a notebook window, the duplicate window appears full size in front of other open windows, with cell A1 selected on the first spreadsheet.
To view different parts of the same notebook, you can duplicate the window or split the window into two panes. Panes can be split vertically or horizontally.
If window panes are synchronized, you can scroll both of them at once to compare the data in rows or columns. Vertically split panes scroll together vertically, and horizontally split panes scroll together horizontally. If you unsynchronize the panes, you can scroll the panes independently to display different parts of the notebook. You can also resize the panes.
To select a notebook window
On the application bar, click the button that displays the window's name.
Note
The window with the highlighted title bar is active.
Tip
You can toggle back and forth between Quattro Pro and a non-spreadsheet window, such as the spelling checker, by pressing Alt + F6.
To arrange notebook windows
To Do the following
Tile windows vertically Click Window Tile top to bottom
Tile windows horizontally Click Window Tile side by side
Have windows overlap Click Window Cascade
Note
When possible, tiled windows are given equal room on the screen.
To hide a notebook window
1 Click the window.
2 Click Window Hide.
Tip
To show a hidden notebook window, click Window Show.
To select a notebook view
1 Click View.
2 Click one of the following views:
Draft - does not display some document elements such as footers, page breaks, and margins, although they may exist in the notebook. Because not all features display, working in Draft view is often faster than working in Page view.
Page - displays your notebook pages the way they will look when printed. Page view displays elements such as fonts, appearance features, headers, footers, footnotes, page breaks, and margins. Page View offers more WYSIWYG (What You See Is What You Get) editing, such as dragging margins and page breaks. You can also get to the Page setup dialog box by double-clicking or right-clicking in a margin.
Page breaks - displays soft and hard page breaks. You can use this view to edit these page breaks.
Objects - displays the Objects sheet, the last sheet in the notebook. You can view your charts, maps, and dialog boxes from this sheet.
Note
The view that is currently selected when you exit Quattro Pro is the view that will appear when you open Quattro Pro again.
Tips
You can drag graphics or charts while in Draft view or Page view.
To see multiple pages while in Page view, click View Zoom, and choose 50 percent (%) or less. To change margins while in Page view, drag a blue margin line to set the current margin for a column or row of pages.
To display formulas instead of formula results
Click View Formulas.
To display spreadsheet comments
Click View Comments.
To display a new view of a notebook window
Click Window New view.
Notes
The New view feature allows you to drag and drop cells between spreadsheets.
When you change border or gridline properties, the change does not display in duplicate views. When you lock titles, split panes, or zoom data, the change does not display in duplicate views.
Tips
To view different areas of open windows, resize them to see a part of each. Scroll windows or select different sheets as desired.
To remove an extra view, click the Close window button at the top-right corner of the window. If you click File Close, all views are closed because all views of the notebook are saved as the same file.
To split a window into two panes
1 Move the mouse pointer to the lower-right corner of the window over the pane splitter.
The pointer changes to a black double-arrow. Depending on where you position the mouse pointer, the double-arrow points horizontally or vertically.
2 Do one of the following:
To create horizontal panes, drag the vertical double-arrow upward. Release the mouse button where you want to split the panes.
To create vertical panes, drag the horizontal double-arrow to the left. Release the mouse button where you want to split the panes.
Tips
You can also split a window into panes using View Split window. The window is split at the position of the selector or, when there is not enough room to split the window at the current position, the window is split in half.
The second pane can be closed by clicking View Split window, and enabling the Clear option.
To synchronize window panes
1 Click View Split window.
2 Enable the Synchronize check box.
To resize window panes
1 Move the mouse pointer over the pane splitter at the lower right of the left or top pane until the double arrow appears.
2 Drag to the new position where you would like the first pane to end.
Note
When you resize panes, the following property changes in one pane do not affect the appearance of the other pane: border or gridline properties, locked titles, row height, column width, default column width, or reveal/hide properties.
Zooming data and hiding and displaying screen components
Zoom lets you see an entire printed page or focus in on the detail of a few cells. You can set zoom for an entire notebook or for individual sheets. The default setting is 100%. Percentages less than 100% show more columns and rows; percentages greater than 100% show fewer. You can also use the Zoom to fit option to automatically fill the screen with the current selection.
You can hide scroll bars, tabs, and graphics. You may want to hide parts of the screen in just one notebook, for example, when you are creating a special presentation notebook or form. Displaying only the outlines of graphics (such as charts, clipart, and shapes) allows you to scroll and print faster.
You can hide parts of the screen in all future notebooks by setting display options. You can also hide borders and grid lines on a spreadsheet. These options are useful when creating a form.
To zoom a notebook
1 Click View Zoom.
2 Select a zoom level.
3 Enable the Notebook option.
Note
The Zoom setting does not affect printed output.
Tips
To restore the screen to its normal display, choose 100%.
If you select one cell and choose Selection, Quattro Pro finds the boundaries of the data, then zooms only that cell.
To zoom data to fit on the screen
1 Select the cell or cells to zoom.
2 Right-click a toolbar, and click Data manipulation.
3 Click Zoom to fit.
To hide notebook features
1 Click Format Notebook properties.
2 Click the Display tab.
3 Disable any of the following check boxes:
Vertical scroll bar
Horizontal scroll bar
Sheet tabs
To hide parts of the screen
1 Click Tools Settings.
2 Click Display.
3 Disable the appropriate check boxes.
To hide borders on a spreadsheet
1 Click Format Sheet properties.
2 Click the Display tab.
3 Disable any of the following check boxes:
Row borders
Column borders
To hide grid lines on a spreadsheet
1 Click Format Sheet properties.
2 Click the Display tab.
3 Disable any of the following check boxes:
Horizontal
Vertical
Customizing menus
You can customize the current menu by adding, deleting, and rearranging menu items. You can also change the access keys used in menus. An access key is the underlined letter in a command that executes that command. Pressing an access key can be done instead of mouse-clicking.
You can make various elements in the user interface transparent.
To customize a menu
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Commands.
4 Choose the command you want from the Commands list.
Each command appears under the appropriate menu name.
5 Drag the command to the desired location on a menu.
Note
When you customize menus, the Help topics referring to those menus do not change.
Tips
To add a separator to a menu, select User menus from the list, and drag the separator to the desired location.
To add a new menu or submenu, select User menus from the list, and drag the new menu to the desired location. If you want to remove a menu or menu item, drag it onto the spreadsheet window.
To change the access key on a menu item
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Commands.
4 Choose the command you want from the Commands list.
Each command appears under the appropriate menu name.
5 Click the Appearance tab.
6 In the Caption box, insert an ampersand (&) before the letter you want to use as an access key.
7 Remove any unnecessary ampersands.
Note
Make sure the letter you choose as an access key is unique to the menu or submenu in which you place it.
To make the user interface transparent
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Options.
4 Enable the Make user interface transparent check box.
5 Enable any of the following check boxes:
Command bars-makes command bars transparent
Dockers-makes dockers transparent
UI with color information-makes color information transparent
6 Move the Transparency level slider to the desired percentage.
Note
The transparency options are only available in Windows 2000.
Customizing keyboards
You can assign shortcut keys to menu items. Quattro Pro provides a list of current shortcut keys. You can print the list or export it to a text file. Note that the following keys or key combinations are system keys and are not valid as access keys:
F1
Alt + F6
Alt + Tab
Alt + Esc
Ctrl + Esc
Ctrl + /
You can also restore all keyboard assignments to their original settings.
To assign a shortcut key to a command
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Commands.
4 Choose the command you want from the Commands list.
Each command appears under the appropriate menu name.
5 Click the Shortcut keys tab.
6 Enter a shortcut key combination in the New shortcut key box.
7 Click Assign.
The new shortcut key appears in the Current shortcut keys list box.
Tip
You can remove a shortcut key by selecting a key from the Current shortcut keys box, and clicking Delete.
To print a list of shortcut keys
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Commands.
4 Click the Shortcut keys tab.
5 Click View all.
6 Click Print.
To export a list of shortcut keys to a text file
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Commands.
4 Click the Shortcut keys tab.
5 Click View all.
6 Click Export to CSV.
7 Type a name in the Filename text box.
Notes
You can have up to four layers of keystrokes. For example, the key combination Ctrl + Alt + 1,2,3,4 is accomplished by holding down the Ctrl and Alt keys, and then pressing the 1, 2, 3, and 4 keys in succession.
To automatically resolve keystroke conflicts, enable the Navigate to conflict on assign check box.
To restore all keyboard assignments to their original settings
1 Click Tools Customize.
2 Open the Customization menu.
3 Click Commands.
4 Click the Shortcut keys tab.
5 Click Reset all.
Saving a notebook group
The arrangement of windows on the screen is called a notebook group. It includes the position and size of all notebook windows and the names of the files contained in each window. The positions of chart and dialog windows are not saved as part of a notebook group.
After you have created a notebook group that best suits your needs, you can save this configuration. When you want to use this customized notebook group again, you can restore it.
To save a notebook group
1 Click File Notebook group Save notebook group.
2 Type a filename.
3 Click Save.
Notes
Do not include a filename extension; the .wbs extension is automatically added for notebook group files.
Saving a notebook group does not save the contents of the files within it. Use Save or Save as to save files. Also, if you use Save as, you must click File Notebook group Save notebook group afterward so that Quattro Pro can open the correct file the next time you try to open the notebook group.
To restore a notebook group
1 Click File Notebook group Open notebook group.
2 Choose the drive and folder where the file is stored.
3 Double-click the filename.
Notes
Quattro Pro overlays existing windows with the windows stored in the notebook group file, and then opens the appropriate file for each.
Quattro Pro always opens the latest saved version of files when you open a notebook group. If you leave the notebook group and save a file included in the notebook group, Quattro Pro opens the updated version of the file the next time you click File Notebook group Open notebook group.
Setting multiple workspaces
A workspace is a configuration of settings that specifies how the various command bars, commands, and buttons are arranged when you open the application. You can create, choose, and delete workspaces. You can also import and export workspaces to and from other computers using the same application. For example, you may want a group of users to use a workspace with a similar look and feel.
To create a workspace
1 Click Tools Settings.
2 Click Workspaces.
3 Click New.
4 Type the name of the workspace in the Name of new workspace box.
5 From the Base new workspace on list box, choose an existing workspace on which to base the new workspace.
If you want to include a description of the workspace, type a description in the Description of new workspace box.
To choose a workspace
1 Click Tools Settings.
2 Click Workspaces.
3 Enable a check box beside a workspace in the available workspaces list.
Tip
You can restore the default workspace by pressing F8 while starting the application.
To delete a workspace
1 Click Tools Settings.
2 Click Workspaces.
3 Enable a check box beside a workspace in the available workspaces list.
4 Click Delete.
Note
You cannot delete the default workspace.
To import a workspace
1 Click Tools Settings.
2 Click Workspaces.
3 Click Import.
4 Click Browse.
5 Choose the drive and folder where the file is stored.
6 Double-click the file.
7 Follow the instructions on screen.
To export a workspace
1 Click Tools Settings.
2 Click Workspaces.
3 Click Export.
4 Enable the check boxes beside the workspace items you want to export.
5 Click Save.
6 Type a filename in the Filename box.
7 Click Save.
8 Click Close.
Note
The workspace items available for export are toolbars, menu bars, and the status bar.
Tip
If you have an email client on your system, you can email a workspace as an attachment by clicking Email.
Saving and closing notebooks
Each notebook is saved as its own file. The default filename for the first notebook is NOTEBK1.QPW. The first time you save a notebook, you can accept this default filename or rename the file. You also have the option of applying a password to the notebook.
For information about setting passwords, see "Using password protection."
You can specify a default filename extension for your Quattro Pro files, and a default folder for your work. When you first open Quattro Pro, the default folder appears when you open or save a file. If you open or save a file in another folder, that folder becomes the default folder until you restart Quattro Pro.
For more information on the default folder, see "File-handling options."
If you exit Quattro Pro without saving your document, or if a power or network failure occurs, you will lose your work unless you have selected the document backup option. If you exit Quattro Pro unexpectedly with timed backup activated, you are prompted to recover any open files the next time you start Quattro Pro.
You can extract part of a notebook and save it as a separate file, leaving the original file intact. This is similar to copying the data, but allows you to also copy values or formulas, and to save the notebook's cell names and charts along with specified cells.
When you close a Quattro Pro notebook, you are prompted to save any unsaved changes. When you close a file, you remove the notebook and all its associated information from the desktop. Always save before closing your notebook or exiting Quattro Pro to keep any changes you have made.
To save a notebook
1 Click File Save.
2 Choose the drive and folder where you want to save the file.
3 Type a filename in the Filename box.
4 Click Save.
Tip
You can save all open notebooks at once using Save all.
To save a notebook with a new filename
1 Click File Save as.
2 Choose the drive and folder where you want to save the file.
3 Type a filename in the Filename box.
4 Click Save.
To save a notebook with a password
1 Click File Save as.
2 Choose the drive and folder where you want to save the file.
3 Type a filename in the Filename box.
4 Enable the Password protect check box.
5 Click Save.
6 Type a password.
7 Type the password again for verification.
Tip
To save a file with a password after you have saved it previously, click File Save as, and select Password protect.
To specify a default filename extension
1 Click Tools Settings.
2 Click Compatibility.
3 Enter one to three letters in the Default file type box.
Note
It is useful to specify a different extension if you usually save or open files in a format other than .qpw. For example, if you work mostly with Microsoft Excel files, it would be helpful to specify .xls as the default extension.
To specify a default folder
1 Click Tools Settings.
2 Click File options.
3 In the Default folder list box, specify the default folder.
To back up your notebooks automatically
1 Click Tools Settings.
2 Click File options.
3 Enable the Timed backup every check box.
4 In the Minutes box, set a time interval from 1 to 59 minutes.
Tip
You can change the location of your backup file folder by typing a new path into the Backup file folder box.
To extract part of a notebook
1 Click Tools Data tools Extract to file.
2 In the Cell(s) field, type the cell name or coordinates to be saved.
You can specify noncontiguous selections by separating the selections with commas.
3 Enable one of the following:
Formulas-saves the cells exactly as they are
Values-saves the resulting values instead of the original formulas
4 Type a filename.
Notes
If the selection includes hidden rows or columns, the hidden rows or columns are saved in the new file, and remain hidden when you open the file.
Some cell names and charts saved in the extracted file may not be meaningful if they refer to cells that were not also extracted. You can delete them, reassign them, or ignore them.
To close a notebook
Click File Close.
Note
If you have made any changes to the notebook, you are prompted to save your work.
Tip
You can close all open notebooks at once using Close all.
To exit Quattro Pro
Click File Exit.
Note
If you have changed any files, you are prompted to save your work.
Reference: Getting started
The application bar displays mode and status indicators. For example, if you press Caps lock, the application bar lets you know that Caps lock is on.
Corel Application Recovery Manager (Corel A.R.M.) is an online wizard that allows you to save a notebook and exit Quattro Pro if the program ever becomes unstable.
Mode and status indicators
The following are some of the indicators that can appear on the application bar in Quattro Pro:
Indicator What it means
One or more formulas need to be recalculated. (Press F9 to recalculate the notebook.)
A formula contains a circular cell reference (it refers to itself or to another formula that refers back to it).
Caps lock is on
Num lock is on
Scroll lock is on
Macro recording is in progress
You pressed Ins and are in Typeover mode. Anything you type will overwrite existing data. (To return to Insert mode, press Ins again.)
COPY You are using the Drag and Drop feature to copy cells. (Press Ctrl while dragging cells with the mouse.)
END The End key is on. Any arrow keys you press move the insertion point to the end of an area in the notebook instead of scrolling
EDIT You are in Edit mode. Press F2 to activate Edit mode
INPUT Input is confined to selected cells with the {RestrictInput.Option} macro command. (Press Esc or Enter with no data in the input line to return to Ready mode.)
LABEL The entry you are typing is text (a label)
MOVE You are using the Drag and Drop feature to move cells
POINT The notebook is in Point mode, letting you specify a cell or cells, or view cell names with F3
READY Quattro Pro is ready for you to enter data or choose an option
VALUE The entry you are typing is a number or formula
Corel Application Recovery Manager
Corel Application Recovery Manager (Corel A.R.M.) is an online wizard that allows you to save a notebook and exit Quattro Pro if the program ever becomes unstable. You can also send an online report to Corel that documents the nature of the problem and the events that led to it.
The Corel A.R.M. Wizard opens automatically at program failure and then offers three courses of action:
saving the notebook and closing the application
exiting the application without saving the notebook
continue working
With the last option, there is no guarantee that you can recover any work in your notebook after the last time you saved.
After you have made your selection, you can report the details of the problem to Corel with an attached program log. Your report will be vital part of Corel's product improvement efforts.
