Repeating cells at bottom

[LSGBrydon]

How can I repeat cells at the bottom of a worksheet when I print it?

 

[Gord Dibben]

Excel has no "rows to repeat at bottom" feature.

You either copy the row or cells to just above pagebreaks or add the cells to
the Footer.

For adding a cell value to a Footer you will need a macro.

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").Value
End With
End Sub


Gord Dibben MS Excel MVP