Home

Excel Questions

%3CLINGO-SUB%20id%3D%22lingo-sub-344385%22%20slang%3D%22en-US%22%3EExcel%20Questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-344385%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%3C%2FP%3E%3CP%3ESo%20I'm%20an%20I.T.%20guy%20that's%20new%20to%20Excel.%20I%20know%20just%20enough%20about%20it%20to%20get%20myself%20in%20trouble.%20I%20have%20a%20simple%20Excel%20spread%20sheet%20that%20I%20have%20but%20together%2C%20basically%20long%20story%20short%2C%20I%20need%20to%20be%20able%20to%20do%20this%3A%20I%20want%20to%20take%20one%20column%20and%20take%20the%20sum%20of%20a%20cell%20below%20another%20cell%20and%20display%20the%20difference%20in%20that%20cell%2C%20if%20that%20makes%20sense.%20I%20need%20to%20carry%20that%20formula%20all%20the%20way%20down%20the%20work%20sheet%2C%20very%20simple%20formula%2C%20just%20didn't%20know%20how%20to%20say%20%22continue%20this%20all%20the%20way%20down%20this%20column.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3Eriders36%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-344385%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESum%20Function%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-344443%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-344443%22%20slang%3D%22en-US%22%3EHover%20over%20the%20cell%20you%20want%20to%20%22carry%20down%22%20until%20your%20cursor%20becomes%20a%20%2B%20and%20click%20and%20drag%20down.%3CBR%20%2F%3EGood%20luck!%3C%2FLINGO-BODY%3E
riders36
Occasional Visitor

Hey guys,

So I'm an I.T. guy that's new to Excel. I know just enough about it to get myself in trouble. I have a simple Excel spread sheet that I have but together, basically long story short, I need to be able to do this: I want to take one column and take the sum of a cell below another cell and display the difference in that cell, if that makes sense. I need to carry that formula all the way down the work sheet, very simple formula, just didn't know how to say "continue this all the way down this column."

 

Thanks,

riders36  

1 Reply
Hover over the cell you want to "carry down" until your cursor becomes a + and click and drag down.
Good luck!
Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
Q&A examples
Dean Gross in Microsoft Search on
0 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
Need to extract values from named cells (Get and Transform)
JEMagnussen in Excel on
23 Replies