How to subtract rows?

%3CLINGO-SUB%20id%3D%22lingo-sub-2064840%22%20slang%3D%22en-US%22%3EHow%20to%20subtract%20rows%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2064840%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20looked%20everywhere%20for%20the%20answer%20to%20this%20extremely%20simple%20question.%26nbsp%3B%20All%20cells%20have%20numeric%20values.%3C%2FP%3E%3CP%3EHow%20do%20automatically%20I%20subtract%20row%2023%20from%20row%2024%20across%20ALL%20cells%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2064840%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2064924%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20subtract%20rows%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2064924%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F930739%22%20target%3D%22_blank%22%3E%402ndChance%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20a%20formula%3A%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%20%3DA24-A23%20in%20A25%2C%20then%20fill%20or%20copy%20from%20A25%20to%20the%20right%20as%20far%20as%20needed.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWithout%20a%20formula%2C%20in%20row%2024%20itself%3A%3C%2FP%3E%0A%3CP%3ESelect%20row%2023%20and%20copy%20it.%3C%2FP%3E%0A%3CP%3ERight-click%20the%20row%20number%20of%20row%2024.%3C%2FP%3E%0A%3CP%3ESelect%20'Paste%20Special...'%20from%20the%20context%20menu.%3C%2FP%3E%0A%3CP%3ESelect%20Subtract%2C%20then%20click%20OK.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2065580%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20subtract%20rows%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2065580%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20time.%26nbsp%3B%20However%2C%20neither%20option%20works.%26nbsp%3B%20I%20just%20get%20%23value!%20errors%20or%20it%20enters%20the%20exact%20same%20number%20in%20every%20column%20on%20row%2025.%26nbsp%3B%20I'll%20just%20keep%20using%20the%20calculator%20the%20subtract%20those%20two%20numbers%20and%20manually%20enter%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have looked everywhere for the answer to this extremely simple question.  All cells have numeric values.

How do automatically I subtract row 23 from row 24 across ALL cells?

4 Replies

@2ndChance 

With a formula:

Enter the formula =A24-A23 in A25, then fill or copy from A25 to the right as far as needed.

 

Without a formula, in row 24 itself:

Select row 23 and copy it.

Right-click the row number of row 24.

Select 'Paste Special...' from the context menu.

Select Subtract, then click OK.

@Hans Vogelaar 

 

Thank you for your time.  However, neither option works.  I just get #value! errors or it enters the exact same number in every column on row 25.  I'll just keep using the calculator the subtract those two numbers and manually enter them.

 

@2ndChance 

Could you attach a sample workbook?

@Hans Vogelaar 

Thank you for offering, but I don't know how to make a sample workbook.  I will use a calculator; I know how to do that.