View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brad E. Brad E. is offline
external usenet poster
 
Posts: 76
Default Copying tab loses formatting

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.