Using mousewheel to scroll through non-fixed part of sheet

[Pantryman]

Hi all,

I have fixed the first 30 rows of my sheet and would like to use m
mousewheel to scroll through the non-fixed part of my sheet but Exce
won't let me.

Does anyone know how to do this?

Thanks in advance

 

[Gord Dibben]

How did you "fix" the first 30 rows?

Selected A31 and Window>Freeze Panes?

The general Freeze Panes rule is..........

Columns to the left of and rows above the selected cell will be frozen.

Exception.........

Selecting A1 and Freeze Panes will result in the Freeze lines in the center of
the Window.

Gord Dibben Excel MVP

 

[Pantryman]

Hi Gord,

after re-doing the freeze with your method it is working.

Thanks a lot!

Marinus

 

[Gord Dibben]

Thanks for the feedback. Always good to know what works or doesn't work.

Gord