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 -

Neither of those worked either. I even copied and pasted just one cell, and
the font and font size wouldn't even match up. I was getting sooo
frustrated. Finally, I copied and used paste special, selecting "All using
Source Theme" (I am in Excel 2007). It finally worked.

Lesson for the day: You can only get a true copy if you are using the same
Theme settings in Excel 2007.

Even prior to this, the only thing I didn't like about Excel 2007 was the
themes. Now I dislike it more.

Thanks for the attempts to help, Susan and Michael.
--
Brad E.


"Susan" wrote:

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 -

glad you figured it out, & sorry i didn't get it for you.
i'm sooooo glad i don't have excel 2007 (yet). i'm hoping that excel
2009 or 2010 will fix all those problems that 07 has!
susan


On Nov 20, 2:46*pm, Brad E. wrote:
Neither of those worked either. *I even copied and pasted just one cell, and
the font and font size wouldn't even match up. *I was getting sooo
frustrated. *Finally, I copied and used paste special, selecting "All using
Source Theme" (I am in Excel 2007). *It finally worked.

Lesson for the day: You can only get a true copy if you are using the same
Theme settings in Excel 2007.

Even prior to this, the only thing I didn't like about Excel 2007 was the
themes. *Now I dislike it more.

Thanks for the attempts to help, Susan and Michael.
--
Brad E.



"Susan" wrote:
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 -- Hide quoted text -

- Show quoted text -