Below are the steps to remove the formula while keeping the data. In the drop-down menu select Clear Contents. Learn how to remove excel a formula from the Excel document and keep all the dataDont forget to check out our site httphowtechtv for more free how-to v.
Sometimes you get uncleaned data set in excel I dont want you being banging your head on wall to clean the data set.
I forgot to mention. Im stuck using Excel 2004 Mac btw. You can easily reduce the size of your file or hide the formula from recipients. Select the Clear Formats option.