Jan 15 2021 08:24 AM
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?
Jan 15 2021 08:44 AM
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.
Jan 15 2021 11:25 AM
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.
Jan 15 2021 02:17 PM
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.