Hi,

Excel 2010,
I need to convert sheets to values only, what is the quickest way of doing that retaining the formatting ?


At the moment I am creating a new sheet beside a source sheet then name it with suffix nf then select corner of source , select copy, then corner of new and copy paste >values to it then format it same as previous sheet.


There has to be an easier way I hope.



DBenz