How to lock table on the left?

[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.

[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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"boki" <[email protected]> wrote in message
news:[email protected]...
> 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.

[boki]

It works!

Thanks a lot :D

Best regards,
Boki.

"Max" <[email protected]> wrote in message news:<[email protected]>...
> 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 <at>yahoo<dot>com
> ----
> "boki" <[email protected]> wrote in message
> news:[email protected]...
> > 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.

[Max]

Pleased to hear that !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"boki" <[email protected]> wrote in message
news:[email protected]...
> It works!
>
> Thanks a lot :D
>
> Best regards,
> Boki.

[MartinShort]

Something extra you might not be aware of is that this doesn't work for printing.

If you want to print that view, you need to go to File->Page SetUp, select the Sheets Tab and then fill in the "Rows to Repeat at Top" and "Columns to Repeat at Top boxes".

Enjoy

M