How to rename a Worksheet in Excel 2007?

When you open a new Excel 2007 workbook, you will have three worksheets to work with by default. When you’re only using one worksheet there’s no reason to name it but if you have a lot of them, the naming thing becomes a must if you want to organize your work properly. I’ve asked a few people and they didn’t even know that you can change the name of the worksheet although it’s very simple as you will see.

Step 1: You can either double click on the sheet you want to rename (first picture) or right click on the sheet and select “Rename” from the menu (second picture).

Renaming Worksheets 1

Renaming Worksheets 2

Step 2: Type in the new name of the sheet and press Enter. Done!

Renaming Worksheets 3

  • chinimie

    thanks