Splitting Worksheet

[Harvey Gersin]

How do you split a worksheet in Excel 2007 so that a separate sheet appears
above and current sheet appears below the split line? I need to see a
section of a different sheet while working on another. Thanks.

 

[JP]

Isn't there a View menu where you can arrange the windows
horizontally?

--JP

 

[Gord Dibben]

You don't split the window, you create a new window then arrange the two
horizontally.

You can have whatever sheet or workbook you want in each window.


Gord Dibben MS Excel MVP