Click on the first tab and ctrl-click on subsequent tabs (or right click on any
and choose Select all sheets).

Then do the page setup. Lots of these settings will be applied to all the
sheets that are grouped.

Be careful. Make sure you ungroup the sheets when you're done. Almost all the
changes you make to a grouped sheet will affect the other sheets in that group.

Rightclick on any of the grouped sheets tab and select "ungroup sheets".

Jonno wrote:

Ill be adding new info into them, just words and numbers. But i need to make
sure all the rest get updated!!

how do you do the grouped header and footer?

--
Jonno

"Cath" wrote:

Hi Jonno

You could group the required worksheets and then set up the Headers &
Footers!!

What sort of editing will you be doing to the Headers/Footers?
--

Cath


"Jonno" wrote:

Hi,

I would like all my sheets to have the same header/Footer with out having to
manually input it, each time.

Also the header/Footer on the first sheet will be edited therefore the
header will need to automatically update all the rest of the sheets.

Is this possible?
--
Jonno

--

Dave Peterson