Encrypt all the cells of a column

Microsoft Office 2010 home and student
June 22, 2011 at 02:18:39
Specs: Windows 7
I need to set some formula or rule by which whenever I am entering some value into the cells of a particular column only that cell can be visible. All other cells of that column will be remained encrypted. That means suppose I am keeping my username and passwords in some excel file. There the site name, username can be visible, but the cells in the password column will be in encrypted format. When I click on a cell in that password only that cell's content will be visible to me.

See More: Encrypt all the cells of a column

Report •

June 22, 2011 at 04:56:23
What is the purpose of hiding the passwords but making them visible only when you (or anyone else) clicks on the cell?

Why not just protect the file with a password so that only you can open it?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question