Excel - strange scrolling on autofilter 1

[Stretchwickster]

I'm experiencing a strange problem in Excel only when I select "All" from an autofiltered column. When I scroll the sheet with the mouse-wheel the vertical scrollbar reflects movement but the cells in the sheet do not scroll!

Similarly if I use the down arrow key the cell reference changes in the "Name Box" and the vertical scrollbar again reflects movement but the cells in the sheet do not scroll!

Has anyone experienced this and is there any fix?

Your help would be much appreciated!

Clive
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer."
Paul Ehrlich
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096

 

[gizmo1973]

Have you got your freeze panes on? if so swithch it off then try again.
This can sometimes cause the above problem.

Regards, Phil.

Full Member of Shareholders United.
Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts

 

[xlbo]

heh heh - got there 1st Phil !

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[gizmo1973]

ahhh but am I right is the question!!!!

Regards, Phil.

Full Member of Shareholders United.
Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts

 

[Stretchwickster]

Freeze panes are on but turning them off doesn't completely solve my problem! Freeze panes are turned on:
a) when any item other than "All" is selected from the autofilter combobox
b) when "All" is selected from the autofilter combobox

Situation (a) scrolls properly, situation (b) does not!


Clive
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer."
Paul Ehrlich
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096

 

[gizmo1973]

It sounds lkie you have data above the freeze pane so when you filter to all you cannot go any further as the panes are frozen.

Try: Switch off auto filter, switch off freeze panes.
Then switch on auto filter and see what happens, then if it works Switch off auto filter and freeze your panes (if you really need to) before you swicth your filter back on.

Regards, Phil.

Full Member of Shareholders United.
Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts

 

[xlbo]

Personally - I think you're spot on Phil


Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[Stretchwickster]

Phil,

You hit the nail on the head! Thanks for your reply. Boy, you guys are quick in this forum - it's hand on the buzzer stuff here.

Keep up the good work!

Clive
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"To err is human, but to really foul things up you need a computer."
Paul Ehrlich
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
To get the best answers from this forum see: faq102-5096

 

[gizmo1973]

Someone else must have thought so too (*)


Regards, Phil.

Full Member of Shareholders United.
Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts

 

[gizmo1973]

N.P. Clive.

Regards, Phil.

Full Member of Shareholders United.
Show your true support here:

http://www.shareholdersunited.org/join.php

"Shares not Shirts