How can I “freeze” Columns A-I and still strolls the rows from Column J-P up and down?
In my spreadsheet I would like to stroll J3-P164 up and down. I have not been able to do this (yet). Thanks for any suggestions
Padres Games_vers2.ods (39.6 KB)
The yellow background are games that has already been played and is filled in automatic by putting the winning team in the winner column.
This is not what I want. I want stroll the rows up and down, not the columns from left to right.
starting row/column is J3 to P3 and down to p164
That doesnt make sense!…because it would break the semantical relation between fixed on the left and up|down scrollable on the right!
But you can fix at ROW34, to have the first 33 ROWS fixed and the Rest below »scrollable«
I tried that (so for now I’ll live with doing that), but I did not like the idea as I stroll down the teams will become hidden as I stroll down.
Thanks for letting me know there no other way then creating two worksheet, one that has the results (A2-I33) and the other worksheet has the games date.
Let’s solve it with using the “Freeze row and Columns” for now.
PKG, see comment to Karolus, thanks for the input. You’re both right.