• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Quick Excel Question

M

MooMooCow

Senior member
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top