Microsoft Office Tutorials and References
In Depth Information
Figure 6-14 To insert a blank worksheet, click the New Sheet button, or right-click any sheet tab
to display a worksheet-focused shortcut menu.
In addition to providing a convenient method for inserting, deleting, renaming, moving,
and copying worksheets, this shortcut menu contains the Select All Sheets command. As its
name indicates, you use this command to select all the worksheets in a workbook, which
you need to do to perform certain functions, such as copying or formatting, on all the
worksheets at once. The View Code command on this shortcut menu launches the Visual
Basic Editor, showing the Code window for the current worksheet.
For more information about the Visual Basic Editor, see Chapter 28, “Recording macros.”
As you can see in the shortcut menu shown in Figure 6-14, the sheet tab shortcut
menu also contains a Tab Color command. If you are a visually oriented person, you
might find color-coding your worksheet tabs to be as useful as changing the worksheet
You can also add multiple worksheets to a workbook at the same time (starting with a
workbook with multiple sheets in it). To do so, click a sheet tab, press Shift, and then click
other sheet tabs to select a range of worksheets—the same number you want to insert—
before clicking Insert Worksheet on the sheet tab shortcut menu. (Notice that Excel adds
[Group] to the workbook title in the window title bar, indicating you have selected a group
of worksheets for editing.) Excel inserts the new worksheets in front of the first worksheet in
the selected range. Note that this does not copy the selected worksheets; it is just a way of
telling Excel how many fresh, blank worksheets you want to insert at once.
For more information about group editing, see “Editing multiple worksheets” in Chapter 8.