Deep Patel: Masking the characters in a cell with Asterisk/Password Characters for text in an excel Cell.

Wednesday, June 5, 2013

Masking the characters in a cell with Asterisk/Password Characters for text in an excel Cell.

Sometimes we enter password in Excel Sheet(eg. Excel vba Utilities)
It is desired that the password be masked using Password Characters(like *)

This can be done by following steps.

1.    Select the step you want to mask with Password Characters




2.    Go to Format Cells>Number >Custom


3.    Enter the Type as mentioned in the below screenshot and press OK


4.    The data in the cell now appears masked as shown below




Posted by Deep at 1:22 AM

8 comments:

  1. AnonymousApril 29, 2014 at 2:06 PM

    Thanks for the tip. Any way to adjust the formatting so the value doesn't show up in the formula bar as well?

    ReplyDelete
    Replies
    1. MrRandoMarch 27, 2016 at 5:46 PM

      Edit the cell's protection properties and check the "hidden" checkbox, then protect the sheet, that worked for me!

      Delete
  2. birthdaywishFebruary 28, 2017 at 7:57 AM

    How to asterisk character at time of input type any digit numer

    ReplyDelete
  3. AnonymousSeptember 22, 2017 at 5:47 AM

    Can we mask the characters as we are typing

    ReplyDelete
  4. Meak WorkspaceMay 27, 2020 at 11:35 AM

    Thanks alot

    ReplyDelete
  5. JustinJanuary 11, 2021 at 7:09 AM

    Ayyyyy right on. Thanks from Florida.

    ReplyDelete
  6. YogiNovember 23, 2021 at 10:02 PM

    ok, But I am unable to copy the data

    ReplyDelete

Subscribe to: Post Comments (Atom)