Scrolling issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles J. Rice - 22 May 2006 21:30 GMT

I have created a large spreadsheet with many worksheets (12). If I have all
of the cells exposed (unhidden) in the first worksheet (main), the
spreadsheet will not scroll. I can select a cell and use the down arrow to
scroll through the cells, but the screen continues stuck on the first 20 or
so rows. If I set the auto filters and select something that is in a cell
not on the first screen, it will jump to that screen and will scroll.

This seems to be affecting only the primary worksheet.

Any help would be greatly appreciated...this reflects approximately 750
manhours of work and yes it is backed up but the back up has the same issue.

Charles

Reply to this Message

Bob Greenblatt - 23 May 2006 12:43 GMT

On 5/22/06 4:30 PM, in article C0976D70.F4F8%cjrice@owt.com, "Charles J.
Rice" <cjrice@owt.com> wrote:

> I have created a large spreadsheet with many worksheets (12). If I have all of
> the cells exposed (unhidden) in the first worksheet (main), the spreadsheet
[quoted text clipped - 9 lines]
>
> Charles

Are the panes frozen? Check the windows menu.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

PhilD - 23 May 2006 14:02 GMT

> Are the panes frozen? Check the windows menu.

Alternatively, I know that in Windoze there's a scroll lock function.
Does this exist in Mac? I don't know as a) I'm not at my Mac; and b) I
never use it anyway.

Anyway, have a look to see if that is the problem.

PhilD

--
<><

Reply to this Message

Jan Putcuyps - 23 May 2006 14:40 GMT

Yes the scroll lock also exists in Mac Excel. It can be turned on/off via a
combination on the keyboard: shift+F14
You can check it by the green light at the bottom of the screen.

Regards,

Jan

On 23-05-2006 15:02, in article
1148389358.949372.208170@38g2000cwa.googlegroups.com, "PhilD"
<phildeaves@yahoo.co.uk> wrote:

>> Are the panes frozen? Check the windows menu.
>
[quoted text clipped - 8 lines]
> --
> <><

Reply to this Message

Charles J. Rice - 23 May 2006 23:37 GMT

Yes and No the panes are frozen. I have auto filters set. If I select using
the auto filters a cell which is not on the first screen, the scrolling
works fine. Or if I hide the first screen of rows I can scroll.

On 5/23/06 4:43 AM, in article C0986D88.6E8B0%bob@nospam.com, "Bob
Greenblatt" <bob@nospam.com> wrote:

> On 5/22/06 4:30 PM, in article C0976D70.F4F8%cjrice@owt.com, "Charles J. Rice"
> <cjrice@owt.com> wrote:
[quoted text clipped - 14 lines]
>
> Are the panes frozen? Check the windows menu.

Reply to this Message

Charles J. Rice - 24 May 2006 02:43 GMT

Yes, I found that somehow the freeze panes option under the Window tab had
been activated...thanks

Charles

On 5/23/06 3:37 PM, in article C098DCAA.F5C8%cjrice@owt.com, "Charles J.
Rice" <cjrice@owt.com> wrote:

> Yes and No the panes are frozen. I have auto filters set. If I select using
> the auto filters a cell which is not on the first screen, the scrolling works
[quoted text clipped - 21 lines]
>>
>> Are the panes frozen? Check the windows menu.

Reply to this Message

Mac Forum / Applications / Excel / May 2006

Scrolling issue