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!
- I love you so so so so so much! ❤️ thank you!
- 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!
- thanks this worked perfectly!
