Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Maybe you are spitting the worksheet instead of freezing panes, or vice versa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to turn off Page Layout View as default view | New Users to Excel | |||
column is hidden in normal view but not print view | Excel Worksheet Functions | |||
settings not saved w/custom view | Excel Worksheet Functions | |||
some view settings could not be applied | Excel Discussion (Misc queries) | |||
Default View Settings | Setting up and Configuration of Excel |