Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Print row and column headings or labels on every page
 

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:

    ShowPrint row and column headings

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

    ShowPrint 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.

Related Office Online discussions

Read related questions and answers from other Microsoft Office customers.

advertisement