Please, review topics below to find answer to your question

Syncronize rows and columns in the Difference Browser window

This topic describes another useful trick, applied to Difference Browser window.

When you browse comparison results, it is very useful if rows and columns have same height and width and corresponding cells are shown on the same places. But usually this is not possible. Rows and columns one the both sheets have different sizes.

You can resolve this in single click:

Toolbar command: Synchronize rows and columns in the worksheet window

xlCompare sets maximum height for every corresponding pair of rows and maximum height for every corresponding pair of columns.

After applying this command your data is aligned and looks perfect. You can browse it and visually control the differences.