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
add comment

2 Answers

After some searching of the Scooter Software forums, I found this post: http://www.scootersoftware.com/vbulletin/showthread.php?t=10928&highlight=align which essentially tells me that alignment doesn't work for non-text files.

I found two workarounds. One was to save my Excel files as text and then compare them. The second, after reading the forum answer several times, was to change the field used as a key field. That was easier, and in my case, made the alignment no longer an issue.

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.