How would I make it so that column C(x) is always the answer to column A(x) + B(x)? For example, right now I'm typing in A1+B1 for column C then A2+B2 and so forth. I'm currently using Excel 07 if that helps.
Select your cell in column C. In the lower right hand corner of the selected cell is the AutoFill tool, click and drag it down column C. Your selected cell will copy it's formula and adjust it in the columns below it.
Depending on the version (I think) you can actually double-click the lower-right corner and it will perform the function through the end of the data range. I do this a lot in my work.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.