Microsoft® Office Excel® 2007 Inside Out

Editing Multiple Worksheets

If you need to create a bunch of similar worksheets, Office Excel 2007 helps you save some clicks and keystrokes. For example, if the workbook you’re creating calls for a separate worksheet 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 worksheet as needed.

Note

For information about moving and copying worksheets to other workbooks, see "Dragging Worksheets Between Workbooks". For more information about formatting, see Chapter 9.

Grouping Worksheets for Editing

You can group any number of worksheets in a workbook and then add, edit, or format data in all the worksheets in the group at the same time. ...