• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3378
  • Last Modified:

Password Mask Cell in Excel

I want to make the Cell in an Excel to be Password masked with * symbol

How would i achieve this
2 Solutions
Dave BrettVice President - Business EvaluationCommented:
While I don't think you could do this directly, depending on how you want users to access the cell you could

- protect the sheet
- put a textbox with a "***" over the cell
- use a UserForm or other code to write the actual cell contents

Do you have a sample or concept to expand upon?


You can use a "Custom Format" as per below...


As Dave said though you probably need to protect the sheet to hide the contents of the formula bar.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now