- Mar 22, 2013
The way I work, I have to repeatedly drag formulas down as I delete rows of data at a time. Sometimes I forget, and this introduces errors into my work. I would like to automate this simple, repetetive process so that every cell in for example Column H (except for a single header row) would include the same formula, all the way down to infinity. So for example, H2 contains the formula =H1+1, H3 contains the formula H2+1, etc. This is not my actual formula, but just an example.