Tip Printed from ExcelTip.com

---

Put a line at Foot of print page


Tip submitted by Rod Shinkfield, Lancashire, UK


To put a line at the foot of each page, open the Header/Footer.
In the middle section of the Footer, type underscores "_" until there are 3 or 4 lines.
In print preview, there will appear a single line at the foot of each page.
If more than a single line shows, remove a number of underscores.
To put a page number in the middle of the line, put equal number of underscores
on each side of the page code "&[Page]".