Open Multiple Windows For The Same Workbook In Excel


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

 

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts