View Multiple Worksheets in Excel Workbook

View two worksheets in same workbook side by side or one above the other horizontally
Implementing the process:
1. Click on the View tab
2. Click on New Window
2. Click on View Side by Side
4. We can view different sheets of the same workbook one above the other horizontally or side by side vertically
5. We can also click on Synchronize Scrolling in the window command group so that when we scroll to view data in one sheet we can view the same rows and columns in the other sheet
6. We can now compare the data easily in both the sheets
Watch the video below to view two worksheets in the same workbook side by side to compare data. Using the ‘synchronous scrolling’ feature you can scroll both the data synchronously and compare row by row.

Further reading
View two or more worksheets at the same time

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.