COLUMNS IN EXCEL
 

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

Try this, Sarah:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"Sarah_Lecturer" wrote in message
...
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 -FormatCellsProtection and uncheck the lock box
Then select you column
Lock those cells - FormatCellsProtection and check the Lock box
Protect the worksheet

--
HTH

Bob Phillips

"Sarah_Lecturer" wrote in message
...
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