Detecting "errors" in formulas

Hi everyone, sorry for language misstakes first, but i'll try to do my best to elaborate problem.

I have some problem with detecting "errors" in formulas.

I have table with simple formula, example, in cell F6 is "=ROUND(D6*E6;2)".

How can i check that in that cell F6 are exactly D6 and E6, or to put it other way, how to check that in formula there are cells frome same row that formula is.

I have large data tables with thousands of rows, and sometimes when copying and moving, and shifting rows, data and all, my formula has "errors" when it multiplys cells from different row.

I'll put a picture to give example and to be more clear what i'm asking.

vrdkhv.jpg

Ok, so "error" in this example is in row 7 and 8. The formula is multiplying wrong cells, cells from differnet rows. How to detect this through the whole sheet.

Thanks.

Try Formulas > Trace Dependents

The OP says he has thousands of rows to check so will trace dependents help?

It looks like the problem is that column-F does not have the same formula all the way down the column, there's subtotals with different formulas every so often, so he can't just copy the formula all the way down the column.

Perhaps if there was some way to filter on the non-subtotal columns (column-C not blank?) then the right formula could be pasted all the way down the filtered sheet?

There is a worksheet posted at MrExcel.

Filter on column-C = exclude-blanks then copy F4 and paste down to F13 seems to work, although whether this will work with the full data set isn't clear - is column-C blank if and only if it's a subtotal row?