Forum Discussion
HELP! stuck excel cell formula I cant get rid of
Hi - I'm no excel guru - was doing a cut/paste of a few hundred rows of data, and somehow hit a wrong key(s), and now can't get rid of this weird formula I inadvertently created, which has my spreads...
tmlmyusername this happened to me as well! I went under the Formulas tab, clicked on "Recently Used" and chose Sum. It then let me put in numbers to add. Once I hit OK, it changed the stuck formula to a sum formula and I was then able to delete it and unfreeze my spreadsheet. Hope this works for you, too!
- This was so helpful! I was so sure I would end up losing a whole lot of work. Pretty ridiculous that the "experts" gave up so quickly, but very grateful that you knew what to do! Thank you!
ricekrispiesde Thank you so much for this helpful solution. I just went searching for a fix and your suggestion was easy and functional. Something in my file makes it happen when I sort, not sure what the glitch is, but it is very frustrating.
- THAT worked. Good to see someone has it figured out before the "experts."
