Microsoft® Excel® 2010 Inside Out

Editing Multiple Worksheets

If you need to create a bunch of similar worksheets, Excel 2010 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 on page 163. 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. ...