Repeating cells at bottom

  • Thread starter Thread starter LSGBrydon
  • Start date Start date
L

LSGBrydon

How can I repeat cells at the bottom of a worksheet when I print it?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
go to command 6
How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
underline in row not repeating 3
Tab referenced to a cell 2
VBA set thick borders around non empty cells in range 0
automatic total of selected cells 6
Display selected cell at bottom of screen 2

Back
Top