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
compare.
Note: It does not matter if you also
have other workbooks open at the
same time.
2 Switch to one of the
workbooks that you want
to compare.
1
2
3 Click the View tab.
4 Click the View Side by
Side icon.
3
4
 
Search JabSto ::




Custom Search