How can I password protect a particular column?

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
 
Top