Working with Multiple Worksheets

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

Naming worksheets

When working with an Excel workbook, it's not always easy to remember where your data is located. Give each worksheet a descriptive name so you can find it within the workbook.

To name a worksheet:

  • Double-click the sheet tab to select it.
  • Type a new name for the worksheet.
  • Press Enter.
  • The worksheet has a descriptive name.

Sheet Tabs