Share [Social9_Share]

Scroll 2 Excel Files Simultaneously

Scroll 2 Excel Files Simultaneously

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

 

Assume that you have 2 excel workbooks..

  • My Data.xlsx and
  • Your Data.xlsx

and both of them are opened

Scroll 2 Excel Files Simultaneously 1

  1. In any one of the opened workbooks go to the View Tab and
  2. Click on View Side by Side
  3. Then make sure that ‘Synchronous Scrolling’ is turned on

 

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

 

Scrolling 2 Sheets of the same Excel Workbook

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.

 

Assume a workbook with 2 sheets

Your Data.xlsx has 2 sheets

  • 2006
  • 2007

and I want to do simultaneous scrolling.. like I just did. To do that

  1. First click on the New Window Option in the View Tab
  2. An additional window of the same excel file will be created
  3. Now you can choose 2 different sheets on each of the window
  4. And then activate synchronous scrolling just like before

 

A few more nifty hacks to help you save time

  1. How to Master Excel Keyboard Shortcuts
  2. Fill Handle Shortcuts
  3. Custom Sorting in Excel
  4. 30 Evergreen Productivity Hacks
  5. Filter Data by Selection

 

  • Sonika Singh

    This is very interesting, I never knew this can also be done, thanks for sharing such an in-site.

Chandeep Chhabra

Popular Posts

© Goodly