HomeMicrosoft OfficeExcelHow to print title on every page in Microsoft Excel?

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.

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021