How do I enter text above rows repeated at top?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet that I have rows repeating at top of each page; however, I
need to add separate text (a Title) above each page of repeating rows. Can
anyone help with this one??? I'm in a real bind for time...

Thanks!
Barb.
 
Hi,

If you go to File -> Page Setup -> Header/Footer -> Custom Header, yo
can put header information which will go on all pages (not sheets). I
you want all sheets, it may be easier to do a quick macro ...


Code
-------------------

Sub SetAllHeaders()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.PageSetup.CenterHeader = "Your header goes right here"
Next ws
End Sub
 
Without code........

Select first worksheet and right-click on sheet tab then "Select all sheets".

Do your header setup on active sheet and it will be done to all sheets.

DO NOT FORGET to "ungroup" sheets after this operation.

Gord Dibben Excel MVP
 
Back
Top