On Thursday, January 10, 2008 12:31:02 AM UTC+8, Kinnaird wrote:
I am trying to password protect a column of single cells but it keeps
protecting the whole work sheet can ant one help?

Step 1 : Select all cells, right click, choose format cells, choose protection, unclick the box that says lock cells

Step 2 : Select the cells that you want to be locked, right click, choose format cells, choose protection, click the box that says lock

Step 3 : Click on Review from Menu Tab - protect sheet - input a password

ALL LOCKED CELLS THAT YOU SELECTED WILL BE LOCKED. ALL UNLOCK CELLS WILL REMAIN UNLOCKED
** ENSURE THAT WHEN YOU PROTECT THE SHEET - UNCLICK THE BOX THAT SAYS "SELECT LOCKED CELLS"