Quick Excel Question

MooMooCow

Senior member
Jan 11, 2007
283
0
0
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.
 

stlcardinals

Senior member
Sep 15, 2005
729
0
76
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.
 

BarkingGhostar

Diamond Member
Nov 20, 2009
8,410
1,617
136
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.