how to do a page set up for all the sheets at once in excel workbo

[HeJa]

how to do a page set up for all the sheets at once in excel workbook (such as
header, footer, page size, page orientation etc).

 

[Paul B]

HeJa, group the sheets, click on the first sheet and hold down shift and
click on the last sheet, do your page setup and then right click on a sheet
and ungroup, all sheets should now be setup the same
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Gord Dibben]

Heja

Note that some of the options are not available with grouped sheets.

Print Area, Print Titles(Rows to repeat at top, Columns to repeat at left).

These are not available.

Gord Dibben Excel MVP