headers in worksheet

[Guest]

I have a six page worksheet or workbook as a template. The top part looks
like a header but is not because nothing come up in view header/footer.
Presently the six individual sheets of the worksheet do not appear connected:
1. How can i put the contents of say the top five lines into a header?
2. how do i then link the sheets for header/footer so that any change in one
say the third sheet appears on the other sheets also?

If you feel I have asked too much, the answer to 1. is more important than 2.

Thank you
Aamir

 

[Arvi Laanemets]

Hi

I have a six page worksheet or workbook as a template. The top part looks
like a header but is not because nothing come up in view header/footer.

You mean in File > Page Setup > Header/Footer? No need for this, instead
check next tab of Page Setup Wizard (Sheet), right.click on selector button
to right of 'Rows to repeat at top', and select top 5 rows from active sheet
(or simply enter $1:$5 or whatever into this field). Repeat this for every
page.

Presently the six individual sheets of the worksheet do not appear connected:
1. How can i put the contents of say the top five lines into a header?
2. how do i then link the sheets for header/footer so that any change in one
say the third sheet appears on the other sheets also?

After you are finished with designing 1st sheet, link header fields on
another worksheet to according header fields on designed one. P.e. you
designed header for sheet Sheet1. On sheet Sheet2 into cell A1 ebter the
formula
=IF(Sheet1!A1="","",Sheet1!A1)
, and copy this formula to whole header range. After that you may select the
header range on Sheet1, copy it, select A1 on Sheet2, and paste special at
first with Formats selected, and afterwards with Column Widths selected. But
when you did have some header cells on Sheet1 formatted as text, then on
Sheet2 according cells must be formatted as General (because no formulas
will work in cells formatted as Text)


Arvi Laanemets

 

[Arvi Laanemets]

A correction: must be
.... check next tab of Page Setup Wizard (Sheet), click on selector button to
right of 'Rows to repeat at top', ...


Arvi Laanemets

 

[Guest]

Arvi

To change one header & or footer and have all worksheets be changed group
the worksheets you want affected. To group all between select the first one
and hold the "Shift" key and select the last one and all will be "grouped".
To only group selected worksheets select the first sheet you want changed and
while holding "CTRL" select each sheet you want grouped, make your changes.
When finished making your changes "UNGROUP" your worksheets. Because any
change made to any one grouped worksheet is applied to all grouped worksheets.

HTH

Mike Rogers

 

[Guest]

Arvi

I just re-read your post!!! You can still effect the change you want by
grouping, changing the top five rows and ungrouping. By grouping you can
formate and place the top five the way you want. Group, entering the info you
want and ungroup. There are some limitations with this but not knowing you
layout this should get you in the ball park.

HTH

Mike Rogers