Viewing worksheets

[Adrian Stockman]

Hi - I can use the Windows Arrange option to display more than one file at the same time. How do I display two or three worksheets from the same workbook at the same time?

[dominicb]

Good afternoon Adrian Stockman

...and welcome to the forum!!

How do I display two or three worksheets from the same workbook at the same time?

Go to Window > New Window. This will create a second "view" of the currently opened workbook. You can create multiple "views" of any workbook, then use the Window > Arrange functionality to display them all at once.

Jusr make sure that you close down all your extra views before you save and close the workbook, or all these views will be available next time you open the file.

HTH

DominicB

[Adrian Stockman]

Thanks Dominic, I really appreciate that!