Oct 20 2023 08:54 AM
Oct 20 2023 08:54 AM
Need to view multiple worksheets at the same time. Need to compare the data for the same row on them all to see the variances.
Would like to have all three scroll and highlight the same row of the one I am working in. Is this possible?
Oct 22 2023 07:19 AM
So far I know, Excel doesn't provide a direct built-in feature to automatically synchronize scrolling and highlighting of rows across multiple worksheets in the same workbook.
However, you can achieve a similar effect with the following steps and a workaround:
Method: Using the Camera Tool to Create a Visual Synchronization
This method creates a visual synchronization between worksheets using the Camera tool. It's a workaround to mimic the effect of synchronized scrolling and highlighting.
Step 1: Set Up Your Worksheets
Step 2: Activate the Camera Tool
Step 3: Take a Picture of the Relevant Rows
Step 4: Synchronize Scrolling
Step 5: Customizing for Your Needs
This method provides a workaround for visual synchronization. It won't automatically highlight rows, but it does give you a visual reference to see the corresponding rows on both sheets as you scroll.
Please note that the availability of features and tools can change with Excel updates, so make sure to check if there are any new features or third-party add-ins that provide better synchronization options in more recent versions of Excel. Since no one has answered it, I entered your question in various AI. This text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Oct 22 2023 08:35 PMSolution
On the ribbon, go to the View tab and click New Window (in the Window Section). This will open a second window of the active workbook (you'll notice the title bar will now say "Book1:2" or "Book1 - 2", depending on your version of Excel). Then, in the same section of the View tab, click View Side by Side. When you first do this, the Synchronous Scrolling button should also be activated, but if it's not, then click it. If the default arrangement of the windows is not ideal, click Arrange All (in the same section of the View tab again), then choose the desired window arrangement, check the box for "Windows of active workbook" and click OK.
NOTE: you can create as many "New Windows" as you want, however, the Synchronous Scrolling option can only be used with two (2) windows at the same time.