How to print title on every page in Microsoft Excel?

Most of the time we might end up having a long workbook with huge amount of data and they have lot of worksheets or pages. The top row can be frozen so that it can indicate the title or the column names in every page but unfortunately when we print this lengthy workbook , the top row will not be printed in all the pages except the first one.

How to print title on every page in Microsoft Excel?

This can be done by specifying property via the page setup settings.

1. Navigate to the Page Layout Tab in Excel and in the Page Setup group , click the Print Titles button.

image2. In the Page Setup dialog , click the Sheet tab and then click the browse button to specify the title or top row under the Print Titles (Rows to repeat at top).

image
3. Click the OK button.Now the title or top row will be printed on every page.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...