Clearing an Array Formula

  • Thread starter Thread starter Bob Salvato
  • Start date Start date
B

Bob Salvato

Excel 2002 - I just figured out how to delete/clear an
array formula that I had entered into a cell. In case
anyone else is having the same problem I did.......

Hit <F2> (to edit formula)
Backspace (to erase entire formula)
Hit <Ctrl><Shift><Enter> (the same way you did when you
entered the formula originaly)

It worked for me.....
 
Or you can just select the whole area which containes the arrayformula and
hit Delete

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top