Home

Renaming an Excel 2007 Worksheet

|
Updated:  
2016-03-27 15:47:21
|
Excel Sales Forecasting For Dummies
Explore Book
Buy On Amazon

The sheet names that Excel 2007 uses for the tabs in a workbook (Sheet1 through Sheet3) are not very descriptive. Luckily, you can easily rename a worksheet tab to whatever helps you remember what you put on the worksheet, provided that this descriptive name is no longer than 31 characters.

Double-click the sheet tab you want to rename.

Double-click the sheet tab you want to rename.

You also can right-click the sheet tab and then click Rename on its shortcut menu. The current name on the sheet tab appears selected.

Replace the current name on the sheet tab by typing a new sheet name.

When you begin typing a new name, the previous name disappears.

Press Enter.

Press Enter.

Excel displays the new sheet name on its tab at the bottom of the workbook window.

About This Article

This article is from the book: 

About the book author:

Greg Harvey is a language scholar who has traced the roots of Tolkien’s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon.