you can also copy & paste all (first)
and then copy & paste column widths (second).
that should take care of the problem.
:)
susan


On Nov 20, 12:55*pm, Michael
wrote:
OK. When I do Copy and paste values I loose the Format myself, but when I
follow procedure it takes the column width w/it.
First Copy and paste special = ALL to your destination file
then in the destination another copy and paste special = values.
In this sequence you copy formats and then get rid of formulas.
--
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.- Hide quoted text -

- Show quoted text -