Group worksheets to save time when you type common data or apply common formatting.
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.