D
DKS
I have a spreadsheet with 1100 rows and 60 columns. I had set a freeze pane
at row 6 and column 5 intersection.
This allowed me to scroll down and keeping the first 5 rows visible at all
times.
Recently a colleague of mine changed the spreadsheet settings. This had an
effect that when I scroll down, even though the cursor goes down, but on the
screen I do not see any movement, ie the top 20 rows that are visible by
default remain. If I unfreeze panes then it goes down where I need.
any idea what setting is changed by my colleague and how do I reset it?
Thanks in anticipation.
at row 6 and column 5 intersection.
This allowed me to scroll down and keeping the first 5 rows visible at all
times.
Recently a colleague of mine changed the spreadsheet settings. This had an
effect that when I scroll down, even though the cursor goes down, but on the
screen I do not see any movement, ie the top 20 rows that are visible by
default remain. If I unfreeze panes then it goes down where I need.
any idea what setting is changed by my colleague and how do I reset it?
Thanks in anticipation.