Print row and column headings or labels on every page

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

Try Office 2010 In Excel 2010, new user interface has been added to make printing even easier.
Watch a video or try Office 2010!

Row headings are the row numbers to the left of the worksheet; column headings are the letters or numbers that appear at the top of the columns on a worksheet.

  1. Click the worksheet.
  2. On the File menu, click Page Setup, and then click the Sheet tab.
  3. Do one of the following:

Print row and column headings

  • Select the Row and column headings check box, and click Print.

Print row and column labels on every page

  • To print column labels on every page, under Print titles in the Rows to repeat at top box, enter the rows that contain the column labels, and then click Print.
  • To print row labels on every page, under Print titles in the Columns to repeat at left box, enter the columns that contain the row labels, and then click Print.
 
 
Applies to:
Excel 2003