Some advise needed please

[mahmed1]

Hi Guys,

I have a football schedule list wher i have the fixtures on one sheet and the group tables on another sheet.

What i want to do is have a projector showing both the fixtures and group tables but i have a problem because i have them over 2 sheets.

Is there a way i can split 2 sheets in half ?

How would you guys go about it?

 

[riclop]

In 2003 go to Window > New Window. Then select Window > Arrange...> select verticle (or whichever) > check Windows of active workbook.

In 2007 go to View > New Window. Then go to View > Arrange All > see above.

You can then select a different sheet in the new window and have it displayed.