Thread: View settings
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DKS DKS is offline
external usenet poster
 
Posts: 103
Default View settings

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.