How to Rename Sheets in Excel 2007

The sheet names that Excel comes up with for the tabs in a workbook (Sheet1 through Sheet3) are, to put it mildly, not very original - and are certainly not descriptive of their function in life!

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).

To rename a worksheet tab, just follow these steps:

1) Double-click the sheet tab or right-click the sheet tab and then click Rename on its shortcut menu. The current name on the sheet tab appears selected.

2) Replace the current name on the sheet tab by typing in the new sheet name.

3) Press Enter. Excel displays the new sheet name on its tab at the bottom of the workbook
window.

Tags: cell range,worksheet

Related Articles