Delete columns in the difference report
xlCompare gives you a comparison report that contains a set of columns that are just a comparison noise. They are not present in another worksheet and marked with green(red) background color. Or they produce a lot of differences, that is not important for your task.
How to get rid of this data on the worksheet?
In xlCompare you can delete the columns link can do it in Excel.
If portion of data is not important for you, do the following to remove it:
- Select the column(s) you want to delete
- Right click on the heading
- Apply Delete command in the context menu
Now your report is clear from the unimportant information.