How do you format multiple worksheets in 2007 Excel?

L

lambert

RE: 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
Link one worksheet in a workbook to another worksheet in same work 1
how do i combine excel worksheets 1
Merging two worksheets that have a common field 4
How to update multiple worksheets? 2
Matching Rows with Multiple Columns in Two Worksheets 0
Insert Page Numbers on Worksheet in Excel 2007 6
merging and mailing multiple worksheets 1

Top