copying sheet without functions

[office user]

Hello to the newsgroup!

I have an excel file with more than 20 sheets containg many functions
relating these sheets. What i want to do is to save SOME of these sheets
to a new file. I want to copy/export only the values of the cells (and not
the functions) but i'd like to keep the colors and general the layout of
each sheet. i know that can copy the source sheet and then do a "special
paste" and insert only the values but this won't keep the colors.

Any ideas? Thanks in advance!

 

[wiseman]

You can do 2 paste specials, one for values as you say and then the same but
choose 'formats'.
Barbara.

 

[office user]

That easy!?! Thanks a lot!

You can do 2 paste specials, one for values as you say and then the same
but
choose 'formats'.
Barbara.