Excel page break question

[tmr064]

I would like to have a bottom border on the cells above each page break. Is there a way to test for page breaks using conditional formating? Or, if there is a standard number of rows per page, can this be used?

Thanks

 

[Fae]

Have you considered putting a border in the footer. Use the Custom Footer box and then Center Section. Use an underscore to draw a line. You need to hold the shift and the underscore in so that it draws a continuous line - 4 rows of it. Your line should appear on every page at the bottom.

I hope this helps and is what you were looking for.

Miracles we do immediately ...
imposibilities take a little longer.