How to Hide and Unhide Excel 2010 Worksheets
How to Insert a Hyperlink to a Different Cell in an Excel 2010 Workbook
Specifying Workbook Properties in Excel 2010

How to Rename an Excel 2010 Worksheet

The sheet names that Excel 2010 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 the worksheet contains, provided that this descriptive name is no longer than 31 characters.


Select the sheet whose tab you want to rename.

The selected worksheet is active and the current sheet name appears in bold letters.


Double-click the sheet tab.

You also can right-click the sheet tab and select 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.

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

Another way to help distinguish worksheets in a workbook is to assign colors to the sheet tabs. For example, you could assign red to the tabs of sheets that need immediate checking and blue to the tabs of sheets that you’ve already checked. Right-click a sheet tab, point to Tab Color, and then select a color on the color palette.

blog comments powered by Disqus
How to Insert a Link to Send an E-mail in an Excel 2010 Worksheet
How to Hide and Unhide Rows and Columns in Excel 2010
How to Insert a Hyperlink to a File or Web Site in Excel 2010
Excel 2010 Data-Entry Etiquette
Comparing Two Excel 2010 Worksheets Side by Side