Working with Multiple Worksheets

When working in Excel group worksheets and freeze certain cells to more effectively navigate worksheets.

Naming worksheets

At the beginning of this course, we learned that the tabs displayed at the bottom of the screen are named Sheet1, Sheet2, and Sheet3. These are not very informative names. Excel 2003 allows you to define a meaningful name for each worksheet in a workbook—Checkbook, Reports, Accounts—so you can quickly locate information.

To name a worksheet:

  • Double-click the sheet tab to select it. The text is highlighted by a black box.

    Sheet1 Tab Selection
  • Type a new name for the worksheet.

    Sheet1 Renamed to Checkbook
  • Press the Enter key.
  • The worksheet now assumes the descriptive name defined.