Using mousewheel to scroll through non-fixed part of sheet

P

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
 
G

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
 
P

Pantryman

Hi Gord,

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

Thanks a lot!

Marinus
 
Top