Locking Columns and rows

  • Thread starter Thread starter Lise
  • Start date Start date
L

Lise

Hi

I can lock either the top row OR a specific column BUT I want to be able to
do both is this possible please
 
Dear Lise

You can lock any column or row..

But you can only freeze the top rows or left columns. For example if you
freeze panes from B2; then Row1 and Column A will get freeze.

If this post helps click Yes
 

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

Locking rows and columns 2
Allowing row deletion in worksheet with locked cells 2
Need to lock 2 rows in a sheet 1
Lock two rows 2
iTunes Library text file imported into Excel 4
Sheet Protection 3
Can't use protection options 1
Locking columns 1

Back
Top