Table Compare finding differences

[brettbarbaro]

This seems like it should be straightforward - maybe I'm missing something. I'm comparing two large xlsx spreadsheets, with hundreds of columns. When I open them in Beyond Compare, I see them side-by-side as expected. Pretty much every row has a difference somewhere. But I don't know how to figure out where the difference is. Differences are highlighted in red if I scroll to the correct column, but do I have to scroll all the way through the columns and visually compare to find the differences, or is there a way to simply jump to where the differences are?

[Aaron]

Hello,

The Table Compare deals with full rows, so it doesn't have the same horizontal navigation like the Text Compare (Ctrl+Shift+N to next difference). The Table Compare does have an option to remove any columns from view that only contain equal cells. In the View menu -> Columns dialog, if you show only the Difference Columns, does this help?