Copying a worksheet from a workbook to another

  • Thread starter Thread starter pcw
  • Start date Start date
P

pcw

I copied a worksheet from one workbook to another workbook
and in the process I lose the print setup of the original
worksheet.

The original sheet no longers fits perfectly on an 8.5 X
11 paper. The sides of the sheet is chopped off.
However, I noticed that the column widths for both sheets
are exactly alike.

How can this be explained if the column widths are
identical yet the copied version does not retain the
perfect print setup?
 
Did you copy the entire worksheet using the Edit-->Move or Copy Sheet
command?

If you simply selected and copied all of the cells on the source sheet the
page setup doesn't come across. For example, your chopped off sides may mean
the destination's page setup has different margins or scaling values.
--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com
 
I selected the sheet and right clicked, and then created a
copy of the original. Finally, I used the move/copy
option.
 
Back
Top