Microsoft Office Tutorials and References
In Depth Information
Editing multiple worksheets
Figure 8-54 With group editing, Excel applies all edits and formats to all the worksheets.
8. When you finish all the entries, common formulas, and formatting, click any
worksheet to ungroup, and then make edits to individual worksheets, such as adding
each month’s name and entering units and sales data.
You can add formatting, formulas, or any other data to the active worksheet in a group,
and Excel modifies all member worksheets simultaneously. Excel transfers any changes you
make to column width, row height, view options such as gridlines and scroll bars, and even
the location of the active cell to the group.
You’ll find the Northwind Brass Sales.xlsx file with the other examples on the companion
INSIDE OUT Group-editing tasks
When you group several worksheets and then click one of the worksheets in the group
with the intention of editing it individually, you’re still in group-editing mode and
could possibly make inadvertent changes to all your grouped worksheets. Keep your
eye on the tabs—when they are white, they are all editable. Getting out of
groupediting mode works differently, depending on how many worksheets you grouped.
If you grouped all the worksheets in a workbook, clicking any tab except that of the
active worksheet exits group-editing mode and removes the [Group] indicator from the
title bar of the workbook. However, if you selected some but not all of the worksheets
in a workbook, clicking any other grouped sheet tab makes that worksheet active but