Apply condition toe Excel Repeating Row

by Gideon   Last Updated April 24, 2018 07:01 AM - source

I am printing a table in Excel and therefore will need its column to repeat on every page when printing. The problem is that the repeating row also appears to the last page where it doesn't need to be.

enter image description here

enter image description here

enter image description here

Notice that in the third and last page, the repeating column is shown. What I want to do is for it not to repeat anymore if there are not table element in the page. Can it be done? I'm using Excel 2016 if that helps.

Note: The rows of the table may vary height in the actual usage of this worksheet. It is not also not always 65 rows, sometimes it goes lower or higher.

I'm using this wizard to set the repeating rows.enter image description here

Related Questions

How to do excel code or formula

Updated July 11, 2017 21:01 PM