How do I copy ALL formating and setup?

[AFD at FONO]

I want to copy ALL the formatting and page setup information from one
worksheet to several others. I've found a way to copy some of the page setup
information but the print area definition isn't copied. The other problem is
that page breaks are not copied. I'm using Excel 2003.

 

[Gord Dibben]

There are some print setups that cannot be done on grouped sheets.

Print Range, rows to repeat at top are included in these "some"

Page Breaks would be a function of your print range being replicated..

You must use VBA code to do that.

For anyone interested in the code see this google search result with Dave
Peterson and myself posting. The print area code is from Bob Flanagan.

http://snipurl.com/106kz


Gord Dibben MS Excel MVP

 

[Pete_UK]

Why don't you just copy the sheet ? (CTRL-drag the sheet tab) Then you
will have an identical sheet, and you can easily remove data (leaving
formulae intact) by Edit | GoTo | Special | Constants and pressing the
<delete> key.

Hope this helps.

Pete

 

[AFD at FONO]

I appreciate your response but it doesn't solve my problem. The next
response does solve the problem.

 

[AFD at FONO]

Many thanks. This came close to solving my problem and worked perfectly with
my test workbook. However, when I tried it on a production workbook I got a
message that said only copy the first 255 characters in a cell would be
copied. Inserting page breaks manually and resetting the print area manually
for each worksheet is much easier than finding all the cells whose contents
has been truncated.

 

[Pete_UK]

Thanks for feeding back.

Pete

Many thanks.  This came close to solving my problem and worked perfectlywith
my test workbook.  However, when I tried it on a production workbook I got a
message that said only copy the first 255 characters in a cell would be
copied.  Inserting page breaks manually and resetting the print area manually
for each worksheet is much easier than finding all the cells whose contents
has been truncated.






- Show quoted text -