Printing Table Border Lines at end of each Page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RFJ - 11 Jan 2007 16:25 GMT

I've got a long table that prints over six pages. It has a border around the
whole table and lines between each column.

I can print the column headings on each page which I've done via the "Rows
to Repeat at Top' option. But is there a way I can print a line at the
bottom of each page ie "Rows to Repeat at bottom' option

TIA

Rob

Reply to this Message

Gord Dibben - 11 Jan 2007 19:18 GMT

No such function in Excel as "rows to repeat at bottom"

What is a "line between each column"? A border line?

Place a bottom border across a row of cells above each pagebreak.

In View>PageBreak View adjust your pagebreaks so the border line between pages
is at the bottom of each page.

Couple of other workarounds.

1. Use custom footer and enter a gang of underscores in left footer.

2. Enter this in an out-of-the-way cell. =REPT(CHAR(151),50))

Then run this macro.

Sub CellInFooter()
With ActiveSheet
.PageSetup.LeftFooter = .Range("X1").Value
End With
End Sub

Where "X1" is the cell with the formula.

Gord Dibben MS Excel MVP

>I've got a long table that prints over six pages. It has a border around the
>whole table and lines between each column.
[quoted text clipped - 6 lines]
>
>Rob

Reply to this Message

Rate this thread: