Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have two Excel (.xls) files that I'm comparing using Beyond Compare 3. When a record is different, it's messing up the alignment, and it doesn't fix itself for several records, so I'd like to manually realign the compare. According to their help, I right-click on a line and choose align. Except that align isn't on the right-click menu. Why?

I'm comparing as 'Detected (MS Excel Workbooks)', Showing All.

share|improve this question

2 Answers 2

It's even easier than that. All you have to do is close the original "Data Compare" window, select the two files to compare in the "Folder Compare" window (hold down the "Ctrl" key to multiselect), then right-click on your selection and select "Open With|Text Compare".

share|improve this answer

I found this post Align with option not available unless using text based files in the Scooter Software forums. It essentially tells me that alignment doesn't work for non-text files.

I found two workarounds:

  1. Save my Excel files as text and then compare them.
  2. Change the field used as a key field.

The second workaround was easier, and in my case, made the alignment no longer an issue.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.