Forum Discussion
Editing / Deleting Array Formulas
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?
3 Replies
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?
HansVogelaar thank you so much! I would like to just remove/clear all the formulas, reorganize the data, and then create new formulas.
Press Control+G or Fn+F5 to activate the Go To dialog.
Click Special...
Select Formulas, then click OK.
Press the Delete key.
