Forum Discussion
How to subtract rows?
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?
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.
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.
Could you attach a sample workbook?
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.
