What about you? Do you use view side by side mode & compare files? Share your experience & tips using comments. It is quick and answers any ad-hoc questions. But back when I was working as a Business Analyst, I used to compare 2 files (or sheets) using this method. Nowadays, I rarely use this mode of comparison as I never have such data. Select sheet 1 in first window, sheet 2 in second window.This opens the same file in one more Excel window. Sometimes, we may have 2 sheets, say this_month & last_month in the workbook and we want to compare both. Like this:īut how to compare data in 2 different sheets in same file? ![]() We want to see both of them together to understand which employees did better in both months. Lets say we have 2 files – this_month.xls and last_month.xls both with our employee productivity data. Lets talk about view side by side mode in Excel and how we can use it in situations like these. We want to compare both and see how they differ. Often we have 2 workbooks with same data structure but different data.
0 Comments
Leave a Reply. |