I have a large calc file with a ton of rows, but only few columns. Is it possible to lock a scrolling axis so that I can eg. only scroll on the y-axis (scrolling up and down)?
If yes: How do I do that?
Hide all columns to the right of the used ones?
Yes, this works.
However, it’s not really what I’m searching for since I want to keep all columns and only lock the sheet to a vertical scrolling direction
How many columns are visible, and how many do you want to lock?
Have you tested with menu View - Freeze Rows and Columns?