Rename a worksheet

  1. On the Sheet tab bar, right-click the sheet tab that you want to rename, and then click Rename Sheet.

Sheet tabs with Sheet2 selected

  1. Select the current name, and then type the new name.

 Tip   You can include the name of the sheet when you print the worksheet.

ShowHow to print sheet names

On the Insert tab, in the Text group, click Header & Footer.

  1. In the Page Layout View, click the location where you want the sheet name to appear.
  2. In the Header & Footer elements group, click Sheet Name Button image.

 
 
Applies to:
Excel 2010