Microsoft Office Tutorials and References
In Depth Information
Editing multiple worksheets
Figure 8-53 Copying a group of worksheets creates the same number of new worksheets.
Right-click any tab, and click Select All Sheets on the shortcut menu; then repeat step
3 to create 12 worksheets.
The easiest way to create a new, blank worksheet is to click the New Sheet
button. The technique described here is especially useful when you want to create
copies of existing worksheets containing data.
Rename the worksheets by double-clicking each tab and typing a new name. We
used the month abbreviations Jan through Dec .
Group all 12 worksheets by selecting their tabs, as described in step 2. Now, any
entries or formatting changes you make in any one of the worksheets are duplicated
in all the worksheets in the group.
Enter and format the text shown in Figure 8-54.