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.

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.

This doesn't work. I should have mentioned that I copied the top ROW from
the source sheet and pasted column widths in the destination sheet, but there
were no further changes in the destination. As I mentioned in the first
post, column B in my source has width of 8.43 (64 pixels) and in the
destination is 8.38 (72 pixels). It appears that the destination is getting
as close to the source as possible (using the 8.xx number), but some kind of
background (or default) formatting isn't allowing the destination to be an
exact duplicate.
--
Brad E.

Many thanks to the people answering questions. I wouldn''t even be
attempting some of the coding I have done without reading these posts.


"Michael" wrote:

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.

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.

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 -

I have the same problem , but i cant solve it, plz help me



Brad wrote:

Copying tab loses formatting
20-Nov-08

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.

EggHeadCafe - Software Developer Portal of Choice
..NET GDI+ Strip Image From Animated Gif
http://www.eggheadcafe.com/tutorials...image-fro.aspx