Forum Discussion
erichthinc
Sep 28, 2020Copper Contributor
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 i...
erichthinc
Sep 28, 2020Copper Contributor
HansVogelaar thank you so much! I would like to just remove/clear all the formulas, reorganize the data, and then create new formulas.
HansVogelaar
Sep 28, 2020MVP
Press Control+G or Fn+F5 to activate the Go To dialog.
Click Special...
Select Formulas, then click OK.
Press the Delete key.