Forum Discussion
tmlmyusername
May 07, 2021Copper Contributor
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...
ricekrispiesde
Nov 09, 2021Copper Contributor
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!
kt1999
Feb 01, 2023Copper Contributor
THAT worked. Good to see someone has it figured out before the "experts."