Viewing two parts of same sheet at once

[Jim \(new user\)]

I am using Excel 2000.

I need to view two parts of the same sheet at the same
time. Help tells me to put my mouse at the top of the
vertical scroll bar, and point to the split box, then
drag.

When I open a blank (new) spreadsheet, the slpit box is
visible. However, when I open any of my existing
spreadsheets, the scroll bar is visible, and works OK,
but there is no split box. Any ideas?

Thanks!!
Jim

 

[DDM]

Jim, don't know why the split box isn't there, but you can try Window >
Split (Excel 2003, but I think the same command is in 2000).

 

[Del]

Jim as a novice on excel I am not sure if Iunderstand what you want but if
you go to Windows on the menu and select switch does help??

 

[CLR]

Have you tried reducing the size of the window (Restore window),and
adjusting it's sixe to about half the screen, then Windows > New
Window..........and then size the two windows to fit on the one
screen..........

Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

Jim

You won't see the Split Box if the existing sheets have Freeze Panes enabled.

Gord Dibben Excel MVP