New Contributor

# 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?

4 Replies

# Re: How to subtract rows?

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.

# Re: How to subtract rows?

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.

# Re: How to subtract rows?

Could you attach a sample workbook?

# Re: How to subtract rows?

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.