Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do you password protect a single cell or column of cells

3,638 views
Skip to first unread message

Kinnaird

unread,
Jan 9, 2008, 11:31:02 AM1/9/08
to
I am trying to password protect a column of single cells but it keeps
protecting the whole work sheet can ant one help?

Bernard Liengme

unread,
Jan 9, 2008, 12:02:16 PM1/9/08
to
Select all the column not to be protected;
Use Format | Cells | protection and deselect the Lock box
Now Tools | Protect | worksheet

Does this give you what you want?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Kinnaird" <Kinn...@discussions.microsoft.com> wrote in message
news:0D46DB91-B014-492A...@microsoft.com...

Kinnaird

unread,
Jan 10, 2008, 12:30:00 PM1/10/08
to
Thanks very much I will try this.
Kinnaird

kayes...@gmail.com

unread,
Jun 19, 2012, 1:33:41 PM6/19/12
to
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"
0 new messages