After pasting values, go back to the source spreadsheet and do copy again,
when you go to the destination spreadsheet, do paste special again and select
paste formats.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Brad E." wrote:

I have a spreadsheet with a "Profile" tab, which gives the profile of our
business. I enter data here and equations access other tabs in this
workbook. When I copy this tab to another workbook for e-mailing to my
manager, I lose the formatting and page setup.

After getting the page all set (including page setup) in my copy, I save my
file. Then close it and open it read-only. From here, I select the whole
range of data and paste values (just to get rid of all formulas). I have
tried 3 different ways to transfer it to the file which my manager will
receive:
Right-click the tab and copy
Right-click the tab and move
View the two worksheets side-by-side, click and drag the tab from mine to
his.
In all 3 situations, the formatting changes. By comparing column widths and
row heights, I see that column A comes over fine, but column B switches from
8.43 (64 pixels) to
8.38 (72 pixels). This distorts the printing and where the page breaks
end up. How can I copy the sheet exactly as I have it in my file?

TIA,
--
Brad E.