![]() |
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. |
View settings
Hi,
Maybe you are spitting the worksheet instead of freezing panes, or vice versa |
All times are GMT +1. The time now is 03:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com