Please note that Microsoft Excel spreadsheets are inherently insecure and spreadsheets containing confidential/sensitive personally identifiable information (like Social Security Numbers and Credit Card Numbers) should never be accessed by unauthorized users. This video demonstrates two formulas you can use to create a column with a masked number. The sensitive data can then be deleted from your sheet. We review how you can hide and protect your sheet, however this is not a fully secure way to protect the data. Even protected sheets should not be shared with unauthorized users. Please consult with your IT or cybersecurity team to ensure you are in compliance with the security policies and practices at your organization. Thanks!
SUPER HELPFUL!! Our HR Department often needs to share some information with other departments but can't share ALL of the employee information. This is great!
Hello sharron how are you I m from Pakistan I am your biggest fan ur videos are very useful and helpful for me I really appreciate your effort best of luck. I m computer operator in a private college u know ur videos helps me alot to solve my problems.
If I share the sheet with someone, they can't enter anything on the sheet because all cells are protected. I want them to enter data. How can I do this?
Please note that Microsoft Excel spreadsheets are inherently insecure and spreadsheets containing confidential/sensitive personally identifiable information (like Social Security Numbers and Credit Card Numbers) should never be accessed by unauthorized users. This video demonstrates two formulas you can use to create a column with a masked number. The sensitive data can then be deleted from your sheet. We review how you can hide and protect your sheet, however this is not a fully secure way to protect the data. Even protected sheets should not be shared with unauthorized users. Please consult with your IT or cybersecurity team to ensure you are in compliance with the security policies and practices at your organization. Thanks!
SUPER HELPFUL!! Our HR Department often needs to share some information with other departments but can't share ALL of the employee information. This is great!
So glad to hear you found it helpful! Thanks for watching!
Nice one Sharon
Thanks so much for watching!
Hello sharron how are you I m from Pakistan I am your biggest fan ur videos are very useful and helpful for me I really appreciate your effort best of luck. I m computer operator in a private college u know ur videos helps me alot to solve my problems.
Hello! I'm so glad to hear my videos have helped you! Thank you so much for watching my Channel! I appreciate it!
@@SharonSmith my pleasure.
If I share the sheet with someone, they can't enter anything on the sheet because all cells are protected. I want them to enter data. How can I do this?
How do we unhide the column? I re-entered the password after clinking unhide but the row didn’t come back up
Can you help me we type number 1 become Ok?
Can u make a video about short cut keys with their names and symbols.
And i just want to say u r absolutely gorgeous means you have incredible beauty.
Thanks for your kind words!
Nice one but not a security advice
Thanks! Yes, I added a pinned comment on that. Thanks for watching!