June 12, 2009

View Two Excel Workbooks in One Window

One of the students in my Beginning Excel class this week asked me how to look at two different Excel workbooks in the same window. It is fairly easy.

First, open one of the workbooks you want to view. Next, click on the Office Button in the upper left hand corner of the window and click on Open. Select the second workbook you want to view, and click on Open. Both workbooks are now open.

Under the View tab, in the Window group, click on Arrange All. You have the option to view the workbooks side by side (Tiled or Vertical), top and bottom (Horizontal) or one on top of the other (Cascade). Clicking in one workbook or the other allows you to edit that workbook.

No comments: