How do I make my spreadsheet so part of it has it's own scrollbar

S

SarahQ

I have a lot of columns, and I want to be able to scroll across some of them
seperately from the core info (i.e. name, title)... Can you help?
 
R

Roger Govier

Hi Sarah

I think you mean Freeze Panes.

If you place your cursor in cell B2 and choose Windows>Freeze Panes
then row 1 and column 1 will be locked and remain visible as you scroll
across or up and down the page.

You can lock as many rows or columns as you want in this manner, it just
depends where you place your cursor before invoking the option.
Windows>Unfreeze Panes will remove it again.
 
Top