O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required