Results 1 to 4 of 4

Thread: MS Excel - Encrypting a column?

  1. #1
    Senior Member Easto's Avatar
    Join Date
    Dec 2000
    So. California

    Question MS Excel - Encrypting a column?

    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?

  2. #2
    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.
    Last edited by ThaDude; 05-13-10 at 12:30 AM. Reason: spelling error

  3. #3
    Senior Member Easto's Avatar
    Join Date
    Dec 2000
    So. California
    Thanks. I think I'm just going to resort to encrypting the complete file and work from there.

  4. #4
    A+, S+, M+, C+, CySA+ Shinobi's Avatar
    Join Date
    Jan 2001
    South Carolina
    Blog Entries

    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.
    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

Similar Threads

  1. Why is there a green check mark on my Word, Excel icons?
    By Marine_One in forum Software Forum
    Replies: 5
    Last Post: 10-30-11, 05:33 PM
  2. More that 2800 Solutions Manuals (Part 2)
    By BERGH in forum alt.internet.wireless
    Replies: 0
    Last Post: 07-25-09, 04:14 PM
  3. excel
    By horsemen_ in forum General Discussion Board
    Replies: 2
    Last Post: 01-02-08, 12:29 AM
  4. Excel Phew!!
    By jeremyboycool in forum General Discussion Board
    Replies: 3
    Last Post: 06-05-07, 06:53 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts