Changing Worksheet Tab Names

By default, all worksheets are named "SheetX," where X is a number starting with the number 1. So that you'll have a better idea of the information each sheet contains, you can change the names that appear on the tabs. Here's how you do it:

  1. Double-click the tab of the worksheet you want to rename. The current name is highlighted.

  2. Type a new name for the worksheet and press Enter. Excel replaces the default name with the name you typed.

In this lesson, you learned how to insert, delete, move, copy, and rename worksheets. In the next lesson, you'll learn how to work with cell ranges.

Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.