Excel : Changing a Worksheet’s Name

By default, Excel names its worksheets Sheet1, Sheet2, and so on. Providing more meaningful names helps you identify a particular sheet. To change a sheet’s name:

1. Double-click the sheet tab, or right-click the sheet tab and choose Rename from the menu that appears. Either method selects the text in the tab.
2. Type the new sheet name directly on the tab.

Excel : Coloring a Worksheet Tab

Excel enables you to add color to a worksheet tab. You can use this feature, for example, to quickly identify a specific worksheet by its color. To color a worksheet tab, follow these steps:

1. Select the worksheet tab that you want to color.
2. Right-click the sheet tab, and choose Tab Color from the menu that appears.
3. Select a color for the tab from the color picker that appears. To undo the tab color, follow the same procedure, but click the No Color option in the color picker.