O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and 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, 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. ...

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