Remove Array Formula

[HotNumbers]

Can some please tell me how I can delete/remove an array formula.

I received a file that has an array. I need to delete the array, but when I do I get the following alert message. You cannot Change Part of an Array.

this is what the formula looks like, only example

{=vlookup(..........)}

I think { } is what is causing the problem.

 

[Aladin Akyurek]

Can some please tell me how I can delete/remove an array formula.

I received a file that has an array. I need to delete the array, but when I do I get the following alert message. You cannot Change Part of an Array.

this is what the formula looks like, only example

{=vlookup(..........)}

I think { } is what is causing the problem.

You have the delete the entire range it occupies.

 

[erik.van.geit]

HotnUmbers,

try this

select B1:B5
type =A1
then hit Ctrl+Shift+ENTER

Select B1 or B2 ... or B5
hit delete
==> not possible

select B1:B5
hit delete
==> possible

instead of deleting you can do other stuff you want

kind regards,
Erik

 

[HotNumbers]

Will try that now. I hope it works.

Thanks

 

[fairwinds]

FWIW

To select a range of cells that contains an array formula:

Click a cell in the array formula.
On the Edit menu, click Go To.
Click Special.
Click Current array.


or use the keyboard shortcut:

CTRL + /

 

[HotNumbers]

Thanks for the tip. Will definetly use it.