Microsoft Office Tutorials and References
In Depth Information
Chapter 11: Inside Excel 2010
To manage worksheets within a workbook, use the controls beneath the worksheet. The
current worksheet name is highlighted in bold. From here, you can select one or more
worksheets, add a new sheet or delete an existing one, rename a sheet or change the color
of its tab, move or copy sheets to the same workbook or a different one, and hide a
worksheet. Figure 11-2 identifies these controls.
Tab scrolling Sheet tabs Insert
Figure 11-2 Use these controls beneath the current worksheet to manage worksheet tabs.
Each worksheet gets its own tab, with the name of the current tab highlighted in bold. If
some tabs aren’t visible, use the tab scrolling buttons to scroll through the tab list or jump
to the first or last tab in the group.
To create a new worksheet, click Insert Worksheet, or use the keyboard shortcut Shift+F11.
Newly created worksheets appear to the right of the last tab in the current workbook and
get a generic name with a number that is one higher than the most recently used
number—Sheet4, Sheet5, and so on. To create a new sheet in a specific location or by using a
saved template, right-click the tab to the right of where you want the new tab to appear,
and then click Insert on the shortcut menu. From the Insert dialog box (shown here) select
Worksheet to create a blank sheet, or choose a previously used template, and then click OK.