Sep 28 2020 12:51 PM
Hi All,
I am trying to manage a big data set (on mac) with loads of pre-existing array formulas. I want to delete the formulas so I can re-organize the data. Can someone help me figure out how to identify and delete the existing array formulas?
Sep 28 2020 12:59 PM
Do you want to remove only array formulas or is it OK to remove all formulas?
And do you want to replace them with their results, or do you want to clear the cells with (array) formulas?
Sep 28 2020 01:05 PM
@Hans Vogelaar thank you so much! I would like to just remove/clear all the formulas, reorganize the data, and then create new formulas.
Sep 28 2020 01:15 PM
Press Control+G or Fn+F5 to activate the Go To dialog.
Click Special...
Select Formulas, then click OK.
Press the Delete key.