If you "save as" and rename the file name, you are making a replica of the
sheet, and renaming as another.



"KathieMacFarlane" wrote:

How do you copy page set up attributes from one worksheet to another. For
examle retaining the margins, the landscape settings, and the "fit to page"
settings.