Compare 2 Excel Files using View side by side Mode [Quick Tip]
Often we have 2 workbooks with same data structure but different data. We want to compare both and see how they differ. Lets talk about view side by side mode in Excel and how we can use it in situations like these.
Lets say we have 2 files – this_month.xls and last_month.xls both with our employee productivity data. We want to see both of them together to understand which employees did better in both months. Like this:
To do this:
- Open both files
- Go to View ribbon
- Turn on “View side by side” mode.
- If promoted, select the other file.
But how to compare data in 2 different sheets in same file?
Sometimes, we may have 2 sheets, say this_month & last_month in the workbook and we want to compare both. Like this:
In such cases:
- Open the file
- Go to View ribbon
- Click on new window. This opens the same file in one more Excel window.
- Enable View side by side mode.
- Select sheet 1 in first window, sheet 2 in second window.
- Compare and be merry!
Do you compare files like this?
Nowadays, I rarely use this mode of comparison as I never have such data. But back when I was working as a Business Analyst, I used to compare 2 files (or sheets) using this method. It is quick and answers any ad-hoc questions.
What about you? Do you use view side by side mode & compare files? Share your experience & tips using comments.
More on Comparison using Excel
If you deal with similar data & compare it often, read these articles to learn more:
- Comparing 2 lists using Conditional Formatting
- Quickly compare 2 lists in Excel
- Comparing a set of first name, last names with another set
- Examples of Comparison charts
- More Excel Quick Tips
Do you want to be awesome in Excel?
Here is a smart way to become awesome in Excel. Just signup for my Excel newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
Leave a Reply
|Last chance to sign-up for my Australian Excel Masterclass [Reminder]||Creating Cash Flow Statement by Indirect Method – II|