MrExcel Publishing
Your One Stop for Excel Tips & Solutions

removing all formulas from a spreadsheet

Posted by DCP on September 06, 2001 6:10 AM

I have created a large Spreadsheet with various table,pages etc, using formulae etc. Now I want to be able to delete all formulas and only leave the values behind. I know that I can do it manually by sheet using Special Paste, but is there a way to do it across 10 sheets in one go.

Posted by Dax on September 06, 2001 6:50 AM

Just select all sheets (Right click any worksheet tab & choose Select All Sheets). Then do your Edit, Goto, Formulas. Press delete et voila!


Posted by DCP on September 07, 2001 5:38 AM

Thanks DAX!