Microsoft Office Tutorials and References
In Depth Information
Editing multiple worksheets
At the bottom of the task pane is a Get Services On Office Marketplace link, which connects
you to the Microsoft Office website, where Excel then checks to see whether there are any
updates to existing services or any new services available that you can add to your research
Editing multiple worksheets
If you need to create a bunch of similar worksheets, Excel 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
For information about moving and copying worksheets to other workbooks, see “Dragging
worksheets between workbooks” in Chapter 6, “How to work a worksheet.” 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. Use this feature when you’re
creating or modifying a set of worksheets that are similar in purpose and structure—a set of
monthly reports or departmental budgets, for example.
You can select and group worksheets by using one of these methods:
Click the sheet tab of the first worksheet in a range of adjacent worksheets you want
to work on, hold down Shift, and click the tab of the last worksheet in the range.
Click the tab of any of the worksheets you want to work on, hold down Ctrl, and click
the tabs of each worksheet you want to include in the group, whether or not the
worksheets are adjacent.
Right-click a sheet tab, and click Select All Sheets on the shortcut menu.
To create a workbook containing a separate worksheet for each month, all you need to
do is open a new workbook and then click the New Sheet button 11 times, as shown in
Figure 8-51.
Search JabSto ::

Custom Search