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
 

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

Repeat Rows at Top - Except Final Page 2
Repeating Rows - Exception 1
Macro to repeat 2 contiguous rows to top of each page 2
Rows to Repeat on Top of everypage EXCEPT for two pages 1
repeat rows at top of page 4
Insert automatic page numbering into a cell, not a header or foote 1
Repeat printing rows in multiple worksheets 19
Change print titles (rows to repeat at top) on subsequent pages 2

Back
Top