headers in worksheet

aamir · External Since: Oct 10, 2006 Posts: 6

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 · External Since: Feb 24, 2005 Posts: 206

Hi

"aamir" <aamir.RemoveThis@discussions.microsoft.com> wrote in message
news:095FC30A-3349-4026-9B0B-04DEC102C2FB@microsoft.com...
> 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

Mike Rogers · External Since: Mar 06, 2006 Posts: 149

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

"Arvi Laanemets" wrote:

> Hi
>
>
> "aamir" <aamir DeleteThis @discussions.microsoft.com> wrote in message
> news:095FC30A-3349-4026-9B0B-04DEC102C2FB@microsoft.com...
> > 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
>
>
>

Mike Rogers · External Since: Mar 06, 2006 Posts: 149

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

"Mike Rogers" wrote:

> 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
>
> "Arvi Laanemets" wrote:
>
> > Hi
> >
> >
> > "aamir" <aamir RemoveThis @discussions.microsoft.com> wrote in message
> > news:095FC30A-3349-4026-9B0B-04DEC102C2FB@microsoft.com...
> > > 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 · External Since: Feb 24, 2005 Posts: 206

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