Splitting Worksheet
 

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.

Splitting Worksheet
 

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

--JP


On Sep 18, 2:14*pm, Harvey Gersin
wrote:
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.

Splitting Worksheet
 

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

On Thu, 18 Sep 2008 11:14:05 -0700, Harvey Gersin
wrote:

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.