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:
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. |