EXCEL

Print row and column labels on every page

1. Click the worksheet.
   
   
2. On the File menu, click Page Setup, and then click the Sheet tab.
   
   
3. To repeat column labels on every page, click Rows to repeat at top, and then enter the rows that contain the column labels.

   To repeat row labels on every page, click Columns to repeat at left, and then enter the columns that contain the row labels.

Note   Microsoft Excel prints repeating row and column labels only on the pages that include the labeled rows or columns. Pages for rows below the labeled rows or columns to the right of the labeled columns are printed without the repeating labels. How to print repeating labels for additional rows or columns.