Fix cell in google sheets for autocomplete to ignore?

Fix cell in google sheets for autocomplete to ignore?

I have a column with values (E) and a cell with another value (F12). I want to multiply both using autocomplete but I don't know how, since autocomplete is going to increase the value of F12 as well.

autocomplete multiplies both columns, not a column and a cell

The only option I know is to copy F12 all over column F and let autocomplete do it's thing, but it's really nasty.

having a column full of the same value is awful

Anyone knows a way to fix F12 or a workaround that won't take me an hour to implement?

Thanks!

PS: using the value of F12 inside the formula is not a solution.

Answer

I know it sucks, it really does. A sunrise at 03:44 seems out of sync

Enjoyed this article?

Check out more content on our blog or follow us on social media.

Browse more articles