Interesting cell formatting in MS Excel to disappear whatever you enter


Here is an interesting cell format that disappears whatever the text you enter..

Step:1.  Select any cell and then click on Format cells dialogue launcher as in the below screen shot (Ctrl + 1 is the keyboard shortcut to invoke Format Cells dialogue)

MS Excel Format Cells dialogue launcher
MS Excel Format Cells dialogue launcher

Step: 2. Select “Custom” in the Category box. Select any arbitrary format style in the Type options. The selected format style will now be available for editing in the Type text box as in the below screenshot.

Number Tab in Format Cells dialogue
Number Tab in Format Cells dialogue

Step: 3. Now change the format style to three consecutive semi-colons (;;;) and then click OK as below. If there is already any content, it becomes invisible from the cell. If any new content is entered, it also becomes invisible, once pressed Enter.

Format Style options in Number tab of Format Cells dialogue
Format Style options in Number tab of Format Cells dialogue

Explanation: Usually cell format takes the below semi-colon separated sytax (full four part syntax):

PositiveNumberFormat; NegativeNumberFormat; ZeroFormat; TextFormat

Since nothing is entered for each of these formats, nothing will be visible in the cell even after entering any contents into the cell.

Remember that this is just the format of cell content and the actual content does not disappear. This is evident when viewed the cell contents from the formula bar or when entered into cell edit mode as can be seen below (see the contents of cell B4 in the cell as well as in the formula bar):

Check Formula bar to see Active Cell Contents
Check Formula bar to see Active Cell Contents

Hope you enjoyed this one.. please do share your comments, questions, compliments..if any.. Have happy time until my next blog.. 🙂

2 thoughts on “Interesting cell formatting in MS Excel to disappear whatever you enter

Add yours

Your valuable comments are highly honoured..!!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Up ↑