Excel 2010 - How to print the table header in all pages

Here are the steps to print a single row in all the pages ONLY while printing. This will be helpful to print a table header in all pages for better visibility.


1. Click “Page Layout” tab in the Ribbon

2. Click “Print Titles” and the following dialog box will open.



3. Click the button (1) to select the necessary row.NOTE: We can select only one Row.
4. Select the necessary row to repeat in all your page.

5. Click the button (1) to confirm the row selection
6. Click Ok to confirm