Feb 25 2022 01:08 PM
Does anyone know if there is a way to prevent one of the values from autofilling when using autofill? For example, if I have
=b2*a1 and use the plus to drag down to autofill, I get
=b3*a2 but what I want is
=b3*a1 so when I drag down through hundreds of rows a1 stays static but b3 continues to autofill.
Feb 25 2022 01:12 PM
SolutionFeb 25 2022 01:12 PM
Solution