koenhermans
New Member
- Joined
- Mar 9, 2016
- Messages
- 4
I have an Excel-document, where we have inserted a horizontal line in the central footer.
Underneath the line we have general information about the author, document classification, page number.
We have inserted a line (wmf) with a length of 40 cm. This with the possibility to turn the page from portrait to landscape, to change the size from A4 to A3, ... without having to change the line.
With some tests we did, the line was always cut off on the page margins (2 cm) and printed perfectly.
Now a user has created an Excel-document based on the template, with two sheets. In sheet1, this works perfectly; but in sheet2 the line continues outside the page margins to the edge of the document, and is not cut off on the page margins.
Strange thing is, when I copy some cells from sheet2 to sheet1, and "paste values", sheet 1 stays ok. But when I do "paste", sheet1 also gets this problem.
All settings in the two sheets seem to be the same.
Anyone any ideas on how to solve this problem? It looks like the line is in front of page margins in sheet2, but I don't know of any command "send to back" or similar...
Sheet1:
Sheet2:
Underneath the line we have general information about the author, document classification, page number.
We have inserted a line (wmf) with a length of 40 cm. This with the possibility to turn the page from portrait to landscape, to change the size from A4 to A3, ... without having to change the line.
With some tests we did, the line was always cut off on the page margins (2 cm) and printed perfectly.
Now a user has created an Excel-document based on the template, with two sheets. In sheet1, this works perfectly; but in sheet2 the line continues outside the page margins to the edge of the document, and is not cut off on the page margins.
Strange thing is, when I copy some cells from sheet2 to sheet1, and "paste values", sheet 1 stays ok. But when I do "paste", sheet1 also gets this problem.
All settings in the two sheets seem to be the same.
Anyone any ideas on how to solve this problem? It looks like the line is in front of page margins in sheet2, but I don't know of any command "send to back" or similar...
Sheet1:
Sheet2:
