Page Setup - Multiple Sheets

[Guest]

Is there a way to perform page setup on multiple sheets at the same time.
i.e. I want to add the same custom header to each of the three workseets in a
workbook without doing them one at a time. Grouping the sheets doesn't work.
I'm still using Excel 2000.
Thanks

 

[Frank Kabel]

Hi
first select all sheets (e.g. hold down the CTRL key while selecting
them) and then apply the page setup

 

[ElsiePOA]

By grouping sheets, do you mean selecting several by clicking sheet tab
while holding down the Ctrl Key?

I use Excel 2000, and that process allows me to set the same headers t
all of the sheets. AFAIK that's the recommended way.

:cool

 

[Guest]

All this time I've been trying to do it from the Page Setup within Page
Preview. It doesn't work that way. If I do it just in Page Setup it works
fine.
Thanks

 

[Kathleen Koch]

It's faster to click the first sheet, hold down the SHIFT
key, then select the last sheet! Viola! all sheets
selected