I think this will work. Make sure you save your file before trying to
do this:

Group all sheets
click on the upper left corner so the whole sheet gets highlighted
(fast way)
Copy
1.Paste Special and select Format click ok
2.Pase Special and select values click ok
(Do them in this order)

I worry about the file size seems I am selecting the whole sheet to
copy and paste. But if it is within the same workbook it shold not be
problem.

Hope this will help you.

Regards,

Cafe


--
cafe
------------------------------------------------------------------------
cafe's Profile: http://www.excelforum.com/member.php...o&userid=16145
View this thread: http://www.excelforum.com/showthread...hreadid=395182