J
Jeff
Hi All
I have a question about freezing panes. I know that you can freeze panes at
one point in your spreadsheet (Say the first 5 rows) whereby you can scroll
down as much as you want and the top 5 rows stay constant on your spread
sheet.
What I am looking to do is to freeze to points on a spreadsheet so that you
can scroll only through a defined area. For example:
Rows 1 through 5 are frozen
Rows 200 through 205 are frozen
So you can only scroll in between rows 6 and 199. That was my column
headers and my totals for the information that I am entering are always
visible on the screen and I can only scroll in between the two frozen pane
area.
Is this possible, either through excel itself or through some variation of
coding?
Any and all comments and assistance with this would be greatly appreciated
and I thank all responses in advance.
Thank you,
Jeff
I have a question about freezing panes. I know that you can freeze panes at
one point in your spreadsheet (Say the first 5 rows) whereby you can scroll
down as much as you want and the top 5 rows stay constant on your spread
sheet.
What I am looking to do is to freeze to points on a spreadsheet so that you
can scroll only through a defined area. For example:
Rows 1 through 5 are frozen
Rows 200 through 205 are frozen
So you can only scroll in between rows 6 and 199. That was my column
headers and my totals for the information that I am entering are always
visible on the screen and I can only scroll in between the two frozen pane
area.
Is this possible, either through excel itself or through some variation of
coding?
Any and all comments and assistance with this would be greatly appreciated
and I thank all responses in advance.
Thank you,
Jeff