Cloud Training (Online)




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.

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.