Forum Discussion
Cris11Ask
Feb 22, 2020Copper Contributor
How to stop auto complete AND spill! error of formulas in following rows/columns?
I'm trying to type a formula just in one cell and when I hit enter it automatically fills the rows next to them and I don't know how to stop that. If I try to delete or put another formula on the nex...
Cris11Ask
Feb 22, 2020Copper Contributor
Thank you! it's nice to know this trick for the future!
Sadly I'll be taken off points if I add stuff to my formulas so I was hoping to deactivate the automatic feature. Any ideas suggestions would be super helpful.
Riny_van_Eekelen
Feb 22, 2020Platinum Contributor
Cris11Ask Put an @ in front of the formula (after the =). But you'll disable a great new feature.