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