Can you split a window in Excel like in Lotus 123? 1

[syl93]

I am converting Lotus 123 spreadsheets to Excel. In the Lotus 123 spreadsheet there is a macro that splits the window and lets you view two different worksheets at the same time. Is there anything like that in Excel? So far I have only found the normal window split that lets you view 2 different parts of the same worksheet, but I can't find anything that lets you view two different worksheets.
Any help would be appreciated.

 

[Scott02]

To see two files at once, you can use the Restore Window button (located between Minimize and Maximize)on each file then move the files and adjust the sizes so you can see each. One on the left, the other on the right. You can also toggle between the two usint Alt-6. Hope it helps.

 

[larryww]

I do the same. BTW it's alt-F6 (though I like Control-Tab for that). Alt-tab is also a way to go for certain versions of office products, if you have opted for separate instance windows. But no, I don't know how you can have two files in one window either.

 

[syl93]

Thanks for the responses, but I need a way to view 2 different worksheets from the same file, not 2 different files. So I guess what I'm hearing is that there isn't a way to do that in Excel?

 

[DaleWatson123321]

Another option....

From the menu, use Window - New Window.

Then, to go from one worksheet to another, hold down <Control> and hit <Tab>.

The <Control> <Tab> of course can also be used to go from one Workbook to another.

I hope this also can be useful.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[Scott02]

Sorry I meant F6. I don't know of anyway to see to sheets of the same file. Maybe you could create a copy of one sheet to a new file and use the method mentioned before.

 

[syl93]

Thanks!

I think I can make the Window - New Window option work for what I need.

 

[AngO]

As a side note to Dale's suggestion - You can also have them both on the screen at the same time.

After you get the New Window open, go to Window/Arrange -
Make your choice, but make sure you put the checkmark in the box for &quot;windows of active workbook&quot;.

AngO

 

[larryww]

Dale is right - that's the way. I think both scott and I misunderstood you to mean 2 worksheet files.