Page 8 of 28PREVNEXT

Audio course: So that's how! Great Excel features

Compare Side by Side command on the Window menu

Use the Compare Side by Side command to compare two workbooks at the same time.

Imagine that you have two workbooks. One is the budget for the Sales department and the other is the budget for the Marketing department. You'd like to compare both workbooks to see the differences in projected expenses between the two departments.

As you can see in the picture, the Window menu shows that both workbooks are already open. Because Marketing is in view, the name of the second worksheet, Sales, is listed after the Side by Side command. To see both workbooks at the same time, you click Compare Side by Side with Sales.

Page 8 of 28PREVNEXT