Microsoft® Office Excel 2003 Inside Out

Editing Multiple Worksheets

If you need to create a bunch of similar worksheets, save yourself some clicks and keystrokes. For example, if the workbook you're creating needs a separate sheet for each month, division, product, or whatever, you can save a lot of time by creating them all at once using the techniques described in this section, and then tweak each sheet as needed. Even if you use worksheet clones in a lot of different workbooks, it's easy to create them all at once and then drag them where you need them.

Cross Reference

For more information about moving and copying sheets to other workbooks, see "Dragging Sheets Between Workbooks". For more information about formatting, see Chapter 8.

Grouping Sheets for Editing

You can group any number ...