I'm trying to compute a bunch of data in excel, and I have a column of data I want to normalize with 1 value. I have the normalization value stored in F128, and my column of data goes from L10 to L29. So I make a new column and give it the equation = L10 / F128, then drag this equation to the rest of the values, so that L increments. How do i make it so the reference to value F128 doesnt change per row? I know i can just copy verbatim the value from F128, but it will probably change, and I might not remeber to alter every column its referenced in.
Posts