Page 14 of 20PREVNEXT

Audio course: So that's how! Working with really big worksheets

Title bar with the word [Group], recurring data in the worksheet, and white worksheet tabs

Group worksheets to save time when you type common data or apply common formatting.
Callout 1 [Group] in the title bar indicates worksheets are grouped.
Callout 2 When the worksheets are grouped, enter common data or apply common formatting on the first sheet.
Callout 3 White worksheet tabs also indicate that worksheets are grouped.

If you create the same report or budget worksheet each week or each month and type the same data each time, such as department, employee, or product names, you can save time by typing common data just once in one worksheet, instead of retyping the same data over and over again in multiple worksheets.

You do this by first grouping together as many worksheets as you want to create. How you group the worksheets depends on how many sheets you want to group together. To group:

  • Two or more adjacent sheets    Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet.
  • Two or more nonadjacent sheets    Click the tab for the first sheet, and then hold down CTRL and click the tabs for the other sheets.
  • All sheets in a workbook    Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

[Group] will appear in the title bar at the top of the worksheet to let you know that you have grouped worksheets.

Then enter all the data on the first sheet that will be common to all the sheets. While the sheets are grouped, you can also apply all the formatting that will be the same; insert the same number of cells, rows, columns, and worksheets; or set up the same headers and footers.

When you are through doing all the work that is the same, ungroup the sheets by clicking any unselected sheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu. [Group] will disappear from the title bar. From there you can go on to make any individual changes that you need to make to each worksheet.

Page 14 of 20PREVNEXT