How can I password protect a particular column?

S

Shamim

I want to hide a column and protect it by a password, so that people may work
on (edit) in other columns and rows with out being able to unhide my hidden
column.
Is that possible?
pls email me: (e-mail address removed)
or (e-mail address removed)
Thanks
 
G

Gord Dibben

You can hide that column then protect the worksheet with a password.

First unlock all cells in the sheet, then lock the column to hide.

Now hide the column.

Tools>Protection>Protect Sheet with a password.

Note: Excel's interanl security is very weak and passwords easily broken.


Gord Dibben MS Excel MVP
 

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

Non cumbersome way to hide and protect a column? 2
How can I password protect a hidden column in Excel? 8
how to protect a column in a spreadsheet 6
protect & hide 1 column & worksheet can continue edit 1
hide, unhide column or row after protect worksheet 4
Protect and hide one column 4
Automatically hide/unhide rows 5
Protect a worksheet but allow cell editing 3

Top