How do I lock a column so it doesn't move when I scroll across?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to lock a column so that it doesn't move when I scroll across my
Excel spreadsheet, is there a way I can do that or no? Please let me know.
 
Select cell B1
Window>Freeze Panes
If you had selected B2 instead, it would keep Row 1 in sight as well


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm trying to lock a column so that it doesn't move when I scroll across my
| Excel spreadsheet, is there a way I can do that or no? Please let me know.
 

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

Scroll Lock 2
Excel Date Setting 1
Formatting Question 2
how do i turn off the scroll lock. 2
scroll lock in Excel only 3
Resetting the scroll bar 1
How to keep 1st column visable when scrolling 1
Can't move between cells. (Not the scroll lock) 1

Back
Top