How to change print preview on multiple tax (xl 2003)

[smerrick]

is there a way in excel 2003 where I can highlight lots of tabs and from this change the print preview (i.e. landscape over 6 pages) as well as freeze panes? I have tried highlighting lots of tabs then do this but only
the first tab is done.

Is there a way?

 

[Trevor G]

Select your first tab, then use Page Setup and alter the Sheet in anyway you want, Landscape, Headers and Footers etc. Then come out of Page Setup. Next Group the sheets together (Use the Ctrl Key and Click Each Sheet Name you want to Group), then Select Page Setup and click OK. This will place all the same settings and information on all the sheets in the group. Remember to Start with the first sheet you altered before grouping.