ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I encrypt Social Security Numbers in Excel worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/39455-how-do-i-encrypt-social-security-numbers-excel-worksheet.html)

gracerod

How do I encrypt Social Security Numbers in Excel worksheet?
 
To comply with federal and university regulations, we need to encrypt
sensitive data, such as Social Security numbers. How can this be done in
Excel?

Doug Kanter


"gracerod" wrote in message
...
To comply with federal and university regulations, we need to encrypt
sensitive data, such as Social Security numbers. How can this be done in
Excel?


Do you actually need to work with those numbers, or are they there just
because they are? And, for each person's record, is there any other unique
identifying number, perhaps one created by the school?



Earl Kiosterud

Grace,

You could hide the column, then protect the sheet with a password. Or you
could put the social security numbers in a separate sheet, along with only
the names and any other stuff that will also uniquely identify people. You
could keep that sheet hidden. You need to say what you're using them for,
if at all, since you don't want them in plain view.
--
Earl Kiosterud
www.smokeylake.com

"gracerod" wrote in message
...
To comply with federal and university regulations, we need to encrypt
sensitive data, such as Social Security numbers. How can this be done in
Excel?





All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com