Quattro Pro Tutorial

Working with Sheets

A notebook can contain up to 18,000 sheets and all except the last one are spreadsheets. (The last sheet is the object sheet.) Each spreadsheet can be moved, renamed, deleted, new sheets added, etc. This tutorial should help you get more familiar with sheets and learn ways to use them to make your work easier.

Contents


Naming Sheets

When your formulas reference cells in other sheets the address will include the sheet’s name as well as the column and row. For example, the cell at address B:A1 would be the top left cell on sheet B. The default sheet names are letters (A, B, C through ZZZ) but you can change their names to something more descriptive by simply right-clicking the sheet’s tab and selecting Edit Sheet Name.

There are some limitations on what you can name your sheets.  Basically you want to avoid using characters in the names that Quattro Pro considers a math operator, +, -, and * for example. Otherwise, spaces are allowed, and so are upper and lower case letters, and the Quattro Pro is not case-sensitive when it comes to accessing named sheets.

Note that even after renaming your sheets that they still retain their original letter names, and these single letter names will always refer to the order of the sheets, even after moving them. For example, if you rename the third sheet (sheet "C") to something like "Third Sheet", you can reference it in your formulas using both the new name and the letter "C". If you later move this sheet, say, ahead of all others, it retains its new name but the letter name will change to "A". But don't worry, Quattro Pro will automatically change all of your cell references from sheet "C" to "A".

Right-click the sheet's tab to bring up a menu that will let you rename it.

Renaming sheets makes it much easier to manage your work.
Back to top

Selecting Sheets

Any sheet, including the objects sheet, can be selected using the mouse or the keyboard. To do this using the mouse simply click the sheet’s tab. If the tab for the sheet you need is not visible you can use the sheet scroll controls to find it. To select the next or previous sheet using the keyboard type CTRL+PgDn or CTRL+PgUp. To quickly go to the top of the first sheet type CTRL+Home.

Sheet Navigation Shortcuts

The following shortcuts make moving from one sheet to the next or previous sheet, or from any sheet to the first, quick and easy.

CTRL-PgDn Move to the next sheet
CTRL-PgUp Move to the previous sheet
CTRL-Home Jump to the first sheet in the notebook
Back to top

Creating (Inserting) and Deleting Sheets

A new spreadsheet can be created and inserted between any two spreadsheets by simply right-clicking the sheet’s tab and selecting Insert Sheet or by selecting Insert|Insert Sheet from the main menu. The process for deleting a sheet is similar. Right-click the tab of the sheet to be deleted and select Delete Sheet from the pop-up menu. There is no equivalent in the main menu for doing this.

Right-click the sheet's tab to bring up a menu that will let you insert a sheet or delete the selected sheet.
Back to top

Moving Sheets

To rearrange the spreadsheets in your notebook simple click and hold the tab of the sheet and drag it to the desired location. If you are moving un-renamed sheets their single letter names will be changed.

To move a sheet simply drag the tab to the desired location.  Note that the Problem 3.25A sheet has been moved ahead of the chapter 2 sheets.
Back to top

Sheet Properties

The properties of each sheet can be changed by either typing CTRL+F12, right-clicking the sheet’s tab and selecting Sheet Properties, or selecting Format|Sheet Properties from the main menu. The figure below gives an idea of what properties one can change.

The sheet properties dialog form
Type CTRL-F12 to bring up this sheet properties dialog. It will let you change many of the sheet-wide characteristics. These changes will apply to only the current sheet.
Back to top

The Objects Sheet

All sheets in your notebook are spreadsheets, except for one. It is the "objects" sheet and it contains all other objects, such as the charts. Your graphs actually reside into this objects sheet.  They are just displayed in your spreadsheet. To view the objects sheet simply View|Objects Page from the main menu.

The "Objects Page" item under the "View" menu will displays the objects sheet where you can access all of the notebook's charts and similar objects directly.

This is a typical objects sheet. All of the charts in this notebook can be accessed here.
Back to top

Hints and Suggestions

  • The ability to rename your sheets leads to thinking about new ways to design your project.  For example, you might make the first sheet a title sheet, the second a summary sheet, and so on.  This can be a very good practice since it'll help you manage the project better by and by breaking up the project into discrete parts sections and defining the main function of each sheet. For the SAMS student, importing data from an experiment into one sheet, performing the calculations on another sheet, performing the analysis of those calculations on yet another sheet, and then summarizing everything on the last sheet not only makes the work go better, but you can reuse the spreadsheet when importing new data and processing it.

  • Naming your sheets, and breaking a large project up into logical parts, not only makes the project easier to complete but it makes it much easier for a reader to understand what you have done.

Back to top