View settings

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.
 
C

curlydave

Hi,
Maybe you are spitting the worksheet instead of freezing panes, or
vice versa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top