Custom header

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

Khalil Handal

Hi,
I have work book with 13 sheets. Sheet 1 has a custom header.
How can I use this header for the other 12 sheets without doing it manualy
for each sheet.
Is there a way?

Khalil
 
If the sheets all have the same Page Set-Up, try this:

Select Sheet1,
Hold down <Shift>.
Select Sheet13,
Then, while all the sheets are Grouped,
<File> <Page Set-Up> <OK>.
Then "Ungroup" the sheets.

This duplicates the Page Set-Up options of Sheet1 to all the rest of the
sheets (including headings).

So, for example, if one sheet was set at landscape, while another was
portrait, they'll all be changed to match the Sheet1 set-up (among other
settings also).

If all the sheets started out the same, then this procedure shouldn't cause
you any problems.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi,
I have work book with 13 sheets. Sheet 1 has a custom header.
How can I use this header for the other 12 sheets without doing it manualy
for each sheet.
Is there a way?

Khalil
 
Hi,
I copied all cells in sheet 1 to the other 12 sheets.
My cutom header has a photo (jpg) on the let side that did not appear on the
other sheet after i tried what you said.
other ideas.
Khalil
 
Try removing the picture from the header.

Then group all the sheets and add the header back.
 
Back
Top