Protecting a single column

[Guest]

Is it possible, within an Excel spreadsheet that is not otherwise protected,
to hide and password-protect a single column of data? I want to have a
spreadsheet with data that is shared with co-workers, but within that
spreadsheet I want to have a column (or several columns) of data that only I
can view.

Thanks,

 

[loudfish]

I want to have a column (or several columns) of data that only I can view.

If your information is really confidential, I would recommend
isolating this into it's own workbook.

Worksheet protection is flimsy. See John Walkenbach's FAQ on the
subject.
http://j-walk.com/ss/excel/faqs/protectionFAQ.htm

HTH

Andrew

 

[Guest]

Only indirectly but you could try:-

Select all the cells on a worksheet and then format|cells|protection and
remove the locked check mark.

Then select the single column you want to hide and repeat the above but this
time check the locked box.

With your column still selected right click and hide the column and then
protect the worksheet. Users cannot now unhide you column and in effect it
isn't protected because all users cells are unlocked.

One warning, Excel protection is pretty useless so anyone with even
rudimentary knowledge could crack this security.

Mike

 

[Guest]

Hi,

Try this:

active all your sheet ( click on the box in the left of column headers and
top of the row numbers ) and the right click on your sheet choos format cells
and then go to protection tab and uncheck the luck checkbox click OK then
active the cells you want to protect and again right click on the active
cells and then format cells and then protection tab and check the luck
checkbox click OK then go to menu Tools>Protection> Protect sheet and follow
the instruction and make your password.

Thanks,

 

[Guest]

Yeah I appreciate the weakness of the security in Excel, but what I'm mainly
trying to do is prevent essentially accidental viewing.

I appreciate all the suggestions, thanks!