Renaming a Spreadsheet


This isn't a necessary technique, but it certainly makes working in a notebook easier when you use names instead of letters to identify spreadsheets. That way, you know exactly which sheet you need to click on when you want to switch to a different spreadsheet.

To rename a spreadsheet to something more meaningful than the alphabet letter Quattro Pro assigned to it, follow these steps:

1.

Right-click the tab of the spreadsheet you want to rename. Quattro Pro displays a shortcut menu (see Figure 4.1).

Figure 4.1. Click Edit Sheet Name to make the spreadsheet name available so that you can change it.


2.

Click Edit Sheet Name. Quattro Pro selects and displays the current name of the spreadsheet.

3.

Type the new name you want to assign to the spreadsheet and press Enter.

Quattro Pro displays the sheet with the name that you assigned to it (see Figure 4.2).

Figure 4.2. You can assign meaningful names to spreadsheets in a notebook.


When you want to refer to formulas in that spreadsheet, you can use the name you assigned or you can use the alphabetic letter Quattro Pro originally assigned to the sheet. Regardless of which name you use, Quattro Pro displays the name you assigned to the sheet in the formula (see Figure 4.3).

Figure 4.3. When you refer to a different sheet in a formula, Quattro Pro uses the name you assigned to the sheet.





Absolute Beginner's Guide to Quattro Pro X3
Absolute Beginners Guide to Quattro Pro X3
ISBN: 0789734265
EAN: 2147483647
Year: 2007
Pages: 128
Authors: Elaine Marmel

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net