I know that I can do this some selection or for the whole worksheet but I
want to know is there any way to do this in just few cliks.

Shahbaz.

" wrote:

shahbaz wrote:
Hi,

I have an excel file with about 40 worksheets containing a lot of links and
formulas. I want to create a copy of this file showing just the values (no
formula and links). Is there any way to copy the whole file as value.
Please send your reply to me at or .

Thanks a lot.

Shahbaz.

Select what you want to copy. Then right click to select "paste
special" and select "values" only to obtain the values without the
formulars and links.