Editing / Deleting Array Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1721939%22%20slang%3D%22en-US%22%3EEditing%20%2F%20Deleting%20Array%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1721939%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20manage%20a%20big%20data%20set%20(on%20mac)%20with%20loads%20of%20pre-existing%20array%20formulas.%20I%20want%20to%20delete%20the%20formulas%20so%20I%20can%20re-organize%20the%20data.%20Can%20someone%20help%20me%20figure%20out%20how%20to%20identify%20and%20delete%20the%20existing%20array%20formulas%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1721939%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1722014%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20%2F%20Deleting%20Array%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1722014%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F812358%22%20target%3D%22_blank%22%3E%40erichthinc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20want%20to%20remove%20only%20array%20formulas%20or%20is%20it%20OK%20to%20remove%20all%20formulas%3F%3C%2FP%3E%0A%3CP%3EAnd%20do%20you%20want%20to%20replace%20them%20with%20their%20results%2C%20or%20do%20you%20want%20to%20clear%20the%20cells%20with%20(array)%20formulas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted

@erichthinc 

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?

Highlighted

@Hans Vogelaar thank you so much! I would like to just remove/clear all the formulas, reorganize the data, and then create new formulas. 

Highlighted

@erichthinc 

Press Control+G or Fn+F5 to activate the Go To dialog.

Click Special...

Select Formulas, then click OK.

Press the Delete key.