Nadia,

Make a third worksheet, and in cell A1, use the formula

=Sheet1!A1=Sheet2!A1

and copy that formula for as large a range as is used on sheet1 and sheet2. Then find the FALSE
values and they will indicate which cells are different.

HTH,
Bernie
MS Excel MVP


"Nadia" wrote in message
...
How do I compare 2 similar excel worksheets?
Both have identical rows and colums, the text may differ in text row, kindly
assist?