Suppose you have created a workbook with a a numbers of sheets, typically a number working data sheets and maybe a summary sheet.

You may want to monitor the cells on the summary sheet whilst still working on one of your other sheets in the same workbook.

In Excel this task is possible by clicking the New Window on the View Tab.

To view both windows on your screen

Hit View> Arrange All>– select any option but not Cascade

In my example below I have selected Horizontal.

Excel has assigned a new name to the new workbook window, and in addition it has changed the original.

In my example it has renamed the windows Widget Sales Summary:2 and Widget Sales Summary:1.  Two Views of the same workbook- how neat is that?.  Sales Summary 1 is the summary sheet and Sales Summary2 is my data sheet.

Other Excel Tips

1. Make All of Your Excel Charts The Same Size

2. Create Your Own Default Excel Template

3. Create A Customer Theme In Excel