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