-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Freeze Row Question
- Thread starter ststern45
- Start date
myall_blues
Well-known Member
- Joined
- Nov 26, 2015
- Messages
- 655
- Office Version
- 365
- Platform
- Windows
No there isn't, but what you see if affected by a combination of the screen size/resolution and the position of the row when you freeze it.
For example, in the following image I set freeze panes at row 40 but row 40 was near the top of the window, so I can only scroll up to row 36 (I can actually scroll past that but being frozen the top rows don't respond).
In this next example, I also froze at row 40, but row 40 is near the bottom of the window so I can scroll up to row 10.
In conjunction with this the size of the screen will affect how many rows/columns you can see overall.
For example, in the following image I set freeze panes at row 40 but row 40 was near the top of the window, so I can only scroll up to row 36 (I can actually scroll past that but being frozen the top rows don't respond).
In this next example, I also froze at row 40, but row 40 is near the bottom of the window so I can scroll up to row 10.
In conjunction with this the size of the screen will affect how many rows/columns you can see overall.
Upvote
0
Solution
