COLUMNS IN EXCEL

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

Guest

Hello!

Wonder if you can help? Is it possible to lock one specific column on an
Excel spreadsheet without protecting the entire sheet?

Thanks for your help

Sarah x
 
Yes.

First make sure the sheet is not protected.
Then unlock all cells -Format>Cells>Protection and uncheck the lock box
Then select you column
Lock those cells - Format>Cells>Protection and check the Lock box
Protect the worksheet
 
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

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How pull ID#s that meet specific "yes" requirements 3
I can only delete an entire row not a cell in excel 2013? 1
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
Help needed 0
Paste without overwriting formulas 1
How to filter rows data based on background color of individual cells 1

Back
Top