MS Excel - Encrypting a column?

General software, Operating Systems, and Programming discussion.
Everything from software questions, OSes, simple HTML to scripting languages, Perl, PHP, Python, MySQL, VB, C++ etc.
Post Reply
User avatar
Easto
SG Elite
Posts: 5860
Joined: Sat Dec 02, 2000 12:00 am
Location: So. California

MS Excel - Encrypting a column?

Post by Easto »

I have the task of enticing our accounts to use our website rather than relying on calling our company all the time. In order to make this easier and to track and handle I will be providing them with a Login and Password.

Without going into all the details...
I will initialy be keeping these passwords in an Excel file. I'd like to encrypt and/or secure the Excel file column that contains these passwords. Can this be done with just 1 column or do I need to encrypt/secure the complete worksheet?
ThaDude
Member
Posts: 87
Joined: Sat Jun 14, 2008 4:54 pm

Post by ThaDude »

The only thing I can come up with is make the color of the text in that column the same as the background so it is unreadable. Then in the save options for that file, set a "Password to Modify" so that only you or the admin can change the color to something else to read the contents of the column.
You might check to make sure you can't read the passwords in that column when you "select all" or highlight a cell or something similar, when the background changes color.
User avatar
Easto
SG Elite
Posts: 5860
Joined: Sat Dec 02, 2000 12:00 am
Location: So. California

Post by Easto »

Thanks. I think I'm just going to resort to encrypting the complete file and work from there.
User avatar
Shinobi
Senior Member
Posts: 4455
Joined: Sat Jan 06, 2001 12:00 am
Location: South Carolina

Post by Shinobi »

https://www.steganos.com/us/products/fo ... /overview/

You may have to change the .xls file extension to .txt.. put you can use this free app, and encrypted the file using AES 256bit encryption. :nod:
_______________________________________________
Vendor neutral certified in IT Project Management, IT Security, Cisco Networking, Cisco Security, Wide Area Networks, IPv6, IT Hardware, Unix, Linux, and Windows server administration
[SIGPIC][/SIGPIC] :thumb:
Post Reply