Publishers of technology books, eBooks, and videos for creative people

Home > Articles > Productivity > Microsoft Excel

  • Print
  • + Share This
This chapter is from the book

Workbook Sheets

Excel workbook files can include many individual sheets, which are like pages in the workbook. Each workbook, by default, includes three sheets named Sheet1 through Sheet3.

There are two kinds of sheets:

  • A worksheet (Figure 1) is for entering information and performing calculations. You can also embed charts in a worksheet.
    Figure 1

    Figure 1 Here's a worksheet.

  • A chart sheet (Figure 2) is for creating charts that aren't embedded in a worksheet.
    Figure 2

    Figure 2 Here's a chart sheet in the same workbook file.

To switch from one sheet to another

Click the sheet tab at the bottom of the workbook window (Figure 3) for the sheet you want.

Figure 3

Figure 3 Use sheet tabs to move from sheet to sheet in a workbook.

Or

Press ctrlpageup or ctrlpagedown to scroll through all of the sheets in a workbook, one at a time.

To select multiple sheets

  1. Click the sheet tab for the first sheet you want to select.
  2. Hold down ctrl and click the sheet tab(s) for the other sheet(s) you want to select. The sheet tabs for each sheet you include in the selection turn white (Figure 6).
    Figure 6

    Figure 6 To select multiple sheets, hold down ctrl while clicking each sheet tab.

To insert a worksheet

  1. Click the tab for the sheet you want to insert a new sheet before (Figure 7).
    Figure 7

    Figure 7 Begin by selecting the sheet you want the new sheet to be inserted before.

  2. Click the New sheet button on the right end of the row of sheet tabs (Figure 3), choose Home > Cells > Insert > Insert Sheet (Figure 8), or press shiftf11.
    Figure 8

    Figure 8 Choose Insert Sheet from the Insert menu.

    A new worksheet is inserted before the one you originally selected (Figure 9).
    Figure 9

    Figure 9 An inserted worksheet.

To insert a chart sheet

  1. Follow the instructions in Chapter 8 to insert a chart in a worksheet (Figure 10).
    Figure 10

    Figure 10 A chart inserted in a worksheet.

  2. Click the chart to select it.
  3. Click Chart Tools > Design > Location > Move Chart to display the Move Chart dialog (Figure 11).
    Figure 11

    Figure 11 The Move Chart dialog lets you insert the chart as a new sheet.

  4. Select the New sheet option and enter a name for the chart sheet.
  5. Click OK.

    A new chart sheet with the name you provided is inserted in the workbook file (Figure 12).

    Figure 12

    Figure 12 An inserted chart sheet.

To delete a sheet

  1. Click the sheet tab for the sheet you want to delete to select it.
  2. Choose Home > Cells > Delete > Delete Sheet (Figure 13).
    Figure 13

    Figure 13 The Delete menu.

  3. A warning dialog (Figure 14) appears. Click Delete to confirm that you want to delete the sheet.
    Figure 14

    Figure 14 When you delete a sheet, Excel warns you that the sheet may contain data.

To rename a sheet

  1. Click the sheet tab for the sheet you want to rename to select it.
  2. Choose Home > Cells > Format > Rename Sheet (Figure 15) or double-click the sheet tab.
    Figure 15

    Figure 15 The Format menu.

  3. The sheet tab becomes highlighted (Figure 16). Enter a new name for the sheet (Figure 17) and press enter to save it.
    Figure 16

    Figure 16 Double-click the sheet tab to select its name.

    Figure 17

    Figure 17 Enter a new name for the sheet.

    The sheet tab displays the new name (Figure 18).
    Figure 18

    Figure 18 Press enter to save the new name.

To change a tab's color

  1. Click the sheet tab for which you want to change the color.
  2. Choose Home > Cells > Format > Tab Color to display a palette of theme and standard colors (Figure 19).
    Figure 19

    Figure 19 Use the Tab Color palette to specify a color for a sheet tab.

  3. Select the desired color.

    The tab color changes as follows:

    • When the tab is selected, it is white but shaded at the bottom with the tab color you specified (Figure 20).
      Figure 20

      Figure 20 When the tab is selected, it is white but shaded at the bottom with the tab color you specified.

    • When the tab is not selected, it appears in the color you specified (Figure 21).
      Figure 21

      Figure 21 When a tab is not selected, its name appears in the color you specified.

To hide a sheet

  1. Select the sheet(s) you want to hide (Figure 18).
  2. Choose Home > Cells > Format > Hide & Unhide > Hide Sheet (Figure 22).
    Figure 22

    Figure 22 The Hide & Unhide submenu on the Format menu.

    The sheet and its sheet tab disappear (Figure 23), just as if it had been deleted. But don't worry, the sheet still exists in the workbook file.
    Figure 23

    Figure 23 When you hide a sheet, its tab disappears.

To unhide a sheet

  1. Choose Home > Cells > Format > Hide & Unhide > Unhide Sheet (Figure 22).
  2. In the Unhide dialog that appears (Figure 24), select the sheet you want to unhide.
    Figure 24

    Figure 24 The Unhide dialog lists all hidden sheets.

  3. Click OK. The sheet and its sheet tab reappear.

To move or copy a sheet

  1. Select the tab(s) for the sheet(s) you want to move or copy.
  2. Choose Home > Cells > Format > Move or Copy Sheet (Figure 15). The Move or Copy dialog appears (Figure 25).
    Figure 25

    Figure 25 Use the Move or Copy dialog to pick a destination for the selected sheet(s) and tell Excel to copy them rather than move.

  3. Use the To book drop-down list (Figure 26) to choose the workbook you want to move or copy the sheet(s) to.
    Figure 26

    Figure 26 The To book drop-down list includes all of the currently open workbook files.

  4. Use the Before sheet list to choose the sheet you want the sheet(s) to be copied before.
  5. If you want to copy or duplicate the sheet rather than move it, turn on the Create a copy check box.
  6. Click OK.
  • + Share This
  • 🔖 Save To Your Account