This post is about one of those times when you realized that you just need to look into the raw data (rather than creating a pivot) and let’s say from 2 or more files.
In order to save you from continuously hitting ALT+TAB you can scroll two or more excel files simultaneously. Yes Seriously..!
Here is how it works
and both of them are opened
Excel will automatically place 2 workbooks side by side or arrange them one below the other. If that does not happen, you can manually size them as per your need.
Now when you scroll (or even use the arrows keys to navigate) any of the 2 workbooks, both windows will scroll simultaneously.
Nifty isn’t it ? But what if my data is on 2 different sheets of the same excel file
In case your data is on different sheets in the same excel workbook then you need to open the excel workbook twice for getting 2 different windows… and you know that is not possible!
But here is how you can open 2 different excel windows for the same excel workbook.
Your Data.xlsx has 2 sheets
and I want to do simultaneous scrolling.. like I just did. To do that