Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Breaking links loses formatting & blank cells in 2007 | Charts and Charting in Excel | |||
Copying SQL Results into Excel loses rows | Excel Discussion (Misc queries) | |||
euro symbol loses formatting if bold | Excel Discussion (Misc queries) | |||
Excel workspace loses formatting | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |