__

Paramix Learning: Repeat Titles In Each Page In Excel

Back to web version

Repeat Titles in Each Page in Excel

By: Eddie Baki, 20.11.2012, 04:26

Getting your table titles to appear on top of each page can be easily fixed.




Printing long and wide Excel table often has the titles appear on the first page, but not on any subsequent pages.

To remedy that, go to the “Page Layout” tab and hit the “Page Titles” button.

In the “Page Setup” Window that appears, click in the field “Rows to repeat at top” and then select the rows you wish to repeat on each page.

Should you have a table, whose width would not fit on one page, you also click in the field “Columns to repeat at left” and then select the columns that you require to have on the left side of each page.

Please use the feedback link below for comments and suggestions.




Copyright © 2016 Paramix e. K.