How to lock table on the left?
 

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.

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"boki" wrote in message
om...
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.

It works!

Thanks a lot :D

Best regards,
Boki.

"Max" wrote in message ...
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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"boki" wrote in message
om...
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.

Pleased to hear that !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"boki" wrote in message
om...
It works!

Thanks a lot :D

Best regards,
Boki.