Viewing 2 Sheets at the Same Time in the Same Excel Workbook

Hello,

I took several classes with you at Cal Poly and the last was the PPT class.

I have an Excel question. Is it possible to see two worksheets from the same workbook at the same time? If so, how do I do this?

Thanks,

Kathy

Hi Kathy,

Yes it is.

First you will need to create a 'new window', basically this creates another window with the same workbook in it.

Go to your View Tab and click on New Window. 

You should see two references to the workbook Name; 1, Name; 2.

Now to arrange them side by side:

Click on View again and click Arrange. I recommend Tiled as the choice.

 

You should now be able to click on different tabs in the same workbook.

Let me know if you have any more problems.

Kelly