How do you format multiple worksheets in 2007 Excel?
 

Excel 2007. I am trying to copy the page setup of a "master" worksheet
to other worksheets in the workbook. In other versions of Excel, it was as
easy as going to the "master" worksheet, highlighting the tabs of the
worksheets I wished to copy the page setup to, going to page setup, and then
clicking OK. Presto! All the highlighted worksheets were now formated
(margins, headings, ect...) just like the "master" worksheet. How this is
done in 2007, I have not discovered.

A solution to this problem would be appreciated.

Thanks.

Lambert