How to get a line to locate at the page break in excel
 

I am trying to get my worksheets with page breaks to print a line across the
active sheet rath than having to format the rows each time a page break
occurs (forced or natural).

How to get a line to locate at the page break in excel
 

had you try using footer?
draw a line and save it, insert at footer

"Heppe85" wrote:

I am trying to get my worksheets with page breaks to print a line across the
active sheet rath than having to format the rows each time a page break
occurs (forced or natural).