limit scroll area of split window panes?

R

rich.trapani

Is it possible to put a limit on the columns/rows that can be scrolled
to when splitting the window into panes? This way the column/row labels
can be visible when you scroll through the main data area, but you
can't accidentally scroll into the labels from the main area, or the
data from the label area.

Thanks,
Rich
 
G

Gord Dibben

You may have better luck with Freeze Panes.

Window>Split is not very functional in my mind.

Select A2 and Window>Freeze Panes to prevent row 1 from scrolling.

Select B2 if you also want Column A to remain in view.

One way to achieve two scrollable windows is Window>New Window followed by
Window>Arrange.

This gives you two scrollable windows.



Gord Dibben MS Excel MVP
 
R

rich.trapani

Awesome! Freeze panes works! Thanks.

Gord said:
You may have better luck with Freeze Panes.

Window>Split is not very functional in my mind.

Select A2 and Window>Freeze Panes to prevent row 1 from scrolling.

Select B2 if you also want Column A to remain in view.

One way to achieve two scrollable windows is Window>New Window followed by
Window>Arrange.

This gives you two scrollable windows.



Gord Dibben MS Excel MVP
Click to expand...
 
Top