Rename worksheet in Excel 2007

When you open a new workbook then Microsoft Excel includes three worksheets labeled Sheet1, Sheet2, and Sheet3. If you add more worksheets then the labels of the newly added worksheets will be Sheet4, Sheet5 and so on. If you are not comfortable with the names of the worksheets then you can rename the worksheets. Perform the following steps to rename the worksheet:
1. Open Microsoft Excel and open the workbook for which you need to rename the worksheet.
2. Click the worksheet that you need to rename (for example: Sheet2). From the Home tab, in the Cells group, click Format, and click Rename Sheet.
3. The text in the worksheet tab gets selected now. Rename the worksheet and press the Enter key.

Other ways of renaming a worksheet is by double clicking the worksheet tab and renaming (or) right-clicking the worksheet tab and clicking Rename.

Worksheet names can be up to 31 characters long and can include spaces. However, you cannot enter the following characters:
* (Asterisk), / (Forward slash), \ (Backward slash), ? (Question mark), and : (Colon).