How to lock table on the left?

  • Thread starter Thread starter boki
  • Start date Start date
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.
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vertical Scroll issue with Excel 2013 1
How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
how to make left side stay still and right side can move left to r 1
how do i turn off the scroll lock. 2
Table headers to remain on top 4
Scroll problem in Excel sheet 1
How to fix the top-most 4 rows when scrolling? 1
Excel 2007 showing empty rows at bottom 1

Back
Top