Hi...In excel, is it possible to enter the data in a cell as invisible data, like password?

Question

I would like to enter the data in a cell as password. I would like to use this data for a if condition in other cell.

Pls. help, if some one has any idea....

Answer 1

Yes, if you change the font color to white on a white background - that will work, of if you're going to put a password in it the cell, you could hide the values in the cell:

1. Select the cells that contain the values you want to hide.
2. On the Format menu, click Cells, and then click the Number tab.
3. In the Category list, click Custom.
4. In the Type box, select the existing codes and press BACKSPACE.
5. In the Type box, type ;;; (three semicolons).
The hidden values appear only in the formula bar — or in the cell if you edit within the cell — and are not printed.

To display hidden values again, select the cells, click the Cells command on the Format menu, and then click the Number tab. In the Category list, click General to apply the default number format. To redisplay a date, a time, or values that have a specific number format, select the appropriate date, time, or number format on the Number tab.

Answer 2

you ought to create a macro. Use help to start. as quickly as you start up up recording a macro, be helpful to furnish it a shortcut key so as which you will basically hit ctl-x or somesuch to run the macro. checklist a macro that copies from sheet a million and then inserts copied cells (shift cells down) the place you elect the information. (in case you have a complete or different formula under, then you certainly will ought to delete and shift up under the information to bypass the whole lower back up.) rather, you turn the macro recorder on, make the replica-pastes you have the desire to make, turn the recorder off -- you could then run those steps directly whenever you elect.

Answer 3

Well, you could enter the data with white font and white background .. or black font and black background.

Otherwise, hide the cell if that works for you.

Answer 4

You can use white text and lock the cell.

Answer 5

you can do soemthing with the colors