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.
Best Answer
You shouldn't need to do manual alignment when doing a data compare: simply select which columns are 'key' columns, and BeyondCompare will do the rest (auto-align based on that).
That's a better option than having to do manual realignment, since it can cope with the entire data set being sorted differently.
(@thursdaysgeek is technically correct that the 'Align With' option is missing (because of this), but I think missed the key point here - this is one of those questions where the OP is asking how to do the wrong thing (no offence intended))