copying sheet without functions

  • Thread starter Thread starter office user
  • Start date Start date
O

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!
 
You can do 2 paste specials, one for values as you say and then the same but
choose 'formats'.
Barbara.
 
Back
Top