Ms Office Tune Up

Many workbooks consist of multiple worksheets that use a similar structure and formatting. For example, a budget workbook might have separate sheets for each division, but each sheet uses the same labels (for sales and expenses), which are formatted the same way for consistency and readability.

If you have just a few worksheets like this, you can copy the labels and formatting from the first sheet and then paste them into the other sheets. However, this isn’t efficient or practical if you’re dealing with a dozen sheets or more. A better solu­tion when you’re dealing with more than a few worksheets is to enter the common text and apply

the common formatting to all the worksheets at the same time. To do that, you first need to group the worksheets with which you want to work. To form a group from multiple sheets, use any of the following techniques:

• To select adjacent sheets, click the tab of the first sheet, hold down the Shift key, and click the tab of the last sheet.
• To select nonadjacent sheets, hold down the Ctrl key and click the tab of each sheet you want to include in the group.
• To select all the sheets in a workbook, right-click any sheet tab and click the Select All Sheets command.

When you’ve selected your sheets, each tab is highlighted and [Group] appears in the work­book title bar.

NOTE

To ungroup the sheets, click a tab that isn’t in the group. Alternatively, you can right-click one of the group’s tabs and select the Ungroup Sheets command from the shortcut menu.

With the sheets now grouped, you can use any of the following techniques:

• To enter text into all the grouped worksheets, activate any grouped worksheet (by clicking its tab), select the cell you want to work with, and then type the text. When you press Enter, Excel adds the text to the same cell in all the grouped sheets.
• To format a cell in all the grouped worksheets, activate any grouped sheet, select the cell you want to format, and then apply the formatting. Excel applies the formatting to the same cell in all the grouped sheets.
• To create a 3D range-the same range selected on multiple worksheets-activate any of the grouped sheets and then select a range. Excel selects the same cells in all the other sheets in the group.

Technorati Tags: text fromatting, multiple worksheets, excel 2007

Popularity: 2% [?]