COLUMNS IN EXCEL

S

Sarah_Lecturer

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
 
B

Bob Phillips

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
 
Top