Microsoft Office Tutorials and References
In Depth Information
Compare Two Workbooks Side by Side
Compare Two Workbooks
Side by Side
You can easily compare two Excel workbooks
by using the View Side by Side command.
It is often useful to compare the contents of
two different workbooks. For example, you
might want to compare two workbooks that
contain the same type of data for two different
divisions, departments, or other entities.
Similarly, you might have sent a copy of a
workbook to a colleague for editing, and you
now want to compare the original and the
copy to see what changes your colleague made.
You could compare the two workbooks by
switching back and forth between them, but
Excel offers a much easier method. With the
View Side by Side command, Excel tiles your
two workbooks within the Excel window, and
as you scroll through one, Excel automatically
scrolls through the other by the same amount.
Note that, despite the name, the View Side by
Side command tiles the workbooks vertically,
not horizontally as you might expect.
1 Open the two workbooks
that you want to
Note: It does not matter if you also
have other workbooks open at the
2 Switch to one of the
workbooks that you want
3 Click the View tab.
4 Click the View Side by