Freezing panes when the content is larger than the viewing area

[popper]

Hi,

I have not had this need before but I have a display which exceeds the height of the viewable area (so that things are readable with my selected zoom size). I want the user to be able to scroll down to the bottom of the area but no further. Freeze panes does not seem to be able to do it.

Any suggestions?

With thanks

 

[combo]

You can hide unused row/columns.
Another option - hide freezing lines: set zoom to 10%, select right-bottom cell, freeze panes and reset zoom.
If you can use macros, set ScrollArea when opening the workbook (property not saved).

combo