Surely you know that you can Windows – Arrange to put two workbooks side-by-side or top-to-bottom. But sometimes I have a bunch of workbooks open and only want to look at a couple of them. If I minimize the windows I don’t want, I can arrange the non-minimized.
In this video I want to compare Book 1 and Book 3. After arranging, I minimize Book 2 and arrange again,
You should try Aaron Blood’s Dualview add-in (http://www.xl-logic.com/); works great for arranging windows and I’ve never had any issues (other than random SAP BI query workbooks).