How to lock table on the left?

B

boki

Hi All,
I saw a excel file, one of its table (one row) could keep in
the left sied of screen when I scrolling the scrolling bar. How to do
that ?

Thanks a lot!

Best regards,
Boki.
 
M

Max

Tinker with this ..

Select B2
Click Window > Freeze pane

Now you can scroll right, and col A will always be in view (frozen)
or scroll down, and row1 will always be in view (frozen)

To undo, just click Window > UnFreeze Panes
 
B

boki

It works!

Thanks a lot :D

Best regards,
Boki.

Max said:
Tinker with this ..

Select B2
Click Window > Freeze pane

Now you can scroll right, and col A will always be in view (frozen)
or scroll down, and row1 will always be in view (frozen)

To undo, just click Window > UnFreeze Panes
Click to expand...
 
Top