This may or may not help but i can see to options
A - Copy all cells and when you past right click and paste specials -
all except borders.
B - Try looking under FORMAT - Conditional Formatting - Delete the
formatting

Hope this helps


--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=547689