Microsoft Office Tutorials and References
In Depth Information
Comparing worksheets side by side
Comparing worksheets side by side
The Arrange All button on the View tab is extremely helpful if you need to compare the
contents of two similar workbooks, but another feature makes this task even easier. The
View Side By Side button essentially packages the Horizontal window arrangement option
with a couple of useful features to make comparison chores a lot easier. The View Side By
Side button lives in the Window group on the View tab; it is the top button located to the
right of the New Window command, as shown in Figure 7-3.
Figure 7-3 If more than two windows are open, select one in the Compare Side By Side
dialog box.
Note
The ribbon on your screen might look different from what you see in this topic. The
ribbon’s display adjusts to the size of your screen, its resolution, and the size of the
Excel window. For example, the six buttons in the middle of the Window group on the
View tab might or might not display adjacent text labels, depending on your screen’s
size and resolution and whether Excel is maximized.
You can click the View Side By Side button to arrange any two open windows even if they
are windows for the same workbook (as described in the next section). But unlike the
Arrange button, View Side By Side performs its trick on no more or less than two windows.
After you click the button, you see a Compare Side By Side dialog box like the one shown
in Figure 7-3 if you have more than two windows open. If so, select the window you want
Search JabSto ::




Custom Search