Page Setup - Multiple Sheets

C

ConEddie

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
 
F

Frank Kabel

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

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
 
C

ConEddie

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
 
K

Kathleen Koch

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