Rename a sheet

The name (or title) of a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) appears on its sheet tab on the Sheet tab bar at the bottom of the screen. By default, the name is Sheet1, Sheet2, and so on, but you can give your worksheet a more appropriate name.

  1. To rename the active sheet, do one of the following:
    • On the Format menu, point to Sheet and then click Rename.
    • On the Sheet tab bar, right-click the tab you want to rename, and then click Rename.

Sheet tabs with Sheet2 selected

  1. Type the new name over the current name.

 Tip   You can include the name of the sheet when you print the worksheet. On the View menu, click Header and Footer, and then, in the Page Setup dialog box on the Header/Footer tab, click Custom Header or Custom Footer. In the Left section, Center section, or Right section box, enter the sheet tab by clicking Tab Button image in the row of buttons in the Header or Footer dialog box.

 
 
Applies to:
Excel 2003