Excel Tip - Compare Data or Multi-Task with Excel

Let's say that you have four separate Excel workbooks, or 2 or more worksheets in the same workbook that you wish to view at the same time.

You may want to compare or copy data between them or set up links. The easiest way to do this is to arrange the worksheets or workbooks next to each other on the screen, here's how it's done:

Arranging Workbooks (separate files)

1.  Have the workbooks open that you wish to arrange

2.  From the Ribbon bar, click the View tab

3.  Click Arrange All

4.  Choose from Tiled, Horizontal, Vertical or Cascade

 

5.  Click OK

Note: to remove this view and revert back to viewing one workbook at a time -  maximise one of the open workbook windows by either double clicking the Title Bar or clicking the Maximise button in the top right-hand corner of the window.

Arranging Worksheets within the same Workbook

Arranging worksheets enables you to view different worksheets at the same time within the same workbook. You can make changes to the worksheets and save the workbook and all changes will appear in the changed worksheets within the same workbook.

1.  Have the Workbook open with the worksheets you wish to arrange

2.  From the Ribbon bar, click the View tab

3.  Select New Window (a mirror image of the workbook will be created with the same file name)
      - on the Title Bar of both windows :1 and :2 will be added to the end of the filename to indicate first and second copy of the workbook

 

4.  Click Arrange All
     
- if you have more than one workbook open, select from the list the workbook that contains the sheets you are trying to arrange

5.  Choose from Tiled, Horizontal, Vertical or Cascade and tick the check box next to "Windows of active workbook"

6.  Click OK

7.  In window :2 click on the worksheet you wish to view along side the worksheet in window :1

Note: to remove this mirrored worksheet view and revert back to viewing one worksheet at a time -  close one of the worksheets using the Close button in the top right-hand corner of the window, and either double click the Title Bar or click the Maximise button in the top right-hand corner of the remaining window.

Pin it