Locking columns

  • Thread starter Thread starter chefatl
  • Start date Start date
C

chefatl

I have a spreadsheet that I want to lock column A so when I scroll t
the right the data will scroll, but column A stays put
 
Select cell B1 and, from the worksheet menu bar, Choose Window | Freeze
Panes

Regards

Trevor
 

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
Scrolling left or right 5
Excel Date Setting 1
Locking columns 3
Scroll Lock 2
Lock column/row in place 1
scroll lock in Excel only 3
Need to lock one column and allow others to scroll 1

Back
Top