Before you do any changes select all sheets (click the first, hold down
shift and click the last), do the changes and then right click any sheet and
select ungroup sheets

--


Regards,


Peo Sjoblom

"fred" wrote in message
...
how can i format an excel workbook all at once instead of by each page
separately (landscape, header, footer)?