Grouping Spreadsheets


If your notebook contains several spreadsheets with similar text or formatting, you can save time editing if you group the similar spreadsheets. When you make a change to a grouped spreadsheet, Quattro Pro changes all the spreadsheets in the group.

For example, in Figure 7.19, you see the Quarter 1 revenue data from training classes. The notebook contains three other spreadsheets for Quarter 2, Quarter 3, and Quarter 4. Suppose that I wanted to apply the same formattingbold and italicsto the month names in all four sheets. I could manually select cells B4.E4 in sheet Qtr1 and apply the formatting and then repeat the process for the other three sheets. Or, I could group the sheets and apply the formatting once, and let Quattro Pro apply the formatting to the other three sheets.

Figure 7.19. A notebook that contains four spreadsheets with similar layouts.


To group sheets, follow these steps:

1.

Open the Insert menu, point to Name, and click Name Group of Sheets. Quattro Pro displays the Define/Modify Group dialog box shown in Figure 7.20.

Figure 7.20. Use this dialog box to define the sheets in a group.


2.

In the Group Name box, type a name for the group; for my example, I named the group Revenue.

3.

In the First Sheet box, type the name of the first sheet in the group.

4.

In the Last Sheet box, type the name of the last sheet in the group.

5.

Click OK and Quattro Pro defines the group.

Tip

You can use spaces in the group name, but not as the initial character of the name.


To work with the group, you must enable group mode. Open the View menu and click Group Mode. Quattro Pro places a thick blue line below the group of sheets (see Figure 7.21) and, on the View menu, a check appears beside the Group Mode command. Quattro Pro applies any formatting changes you make to a cell on any of the sheets to all of the sheets in the group.

Figure 7.21. Quattro Pro displays a thick blue line below the tabs of grouped sheets when you enable Group Mode.


When you want to make changes individually to the grouped sheets, disable Group Mode by opening the View menu and clicking Group Mode again to remove the check that appears beside the Group Mode command. The blue line below the group of sheets also disappears.




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