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.