Viewing two parts of same sheet at once

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim \(new user\) - 30 May 2004 01:37 GMT

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

Reply to this Message

DDM - 30 May 2004 02:03 GMT

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).

Signature

DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

> I am using Excel 2000.
>
[quoted text clipped - 10 lines]
> Thanks!!
> Jim

Reply to this Message

Del - 30 May 2004 19:07 GMT

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??

Reply to this Message

CLR - 30 May 2004 19:24 GMT

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

> I am using Excel 2000.
>
[quoted text clipped - 10 lines]
> Thanks!!
> Jim

Reply to this Message

Gord Dibben - 31 May 2004 20:16 GMT

Jim

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

Gord Dibben Excel MVP

>I am using Excel 2000.
>
[quoted text clipped - 10 lines]
>Thanks!!
>Jim

Reply to this Message