ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   View settings (https://www.excelbanter.com/excel-discussion-misc-queries/170630-view-settings.html)

DKS

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.

curlydave

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