Register now or log in to join your professional community.
<p>By utilising the format cell function, custom, type " ; " character.</p> <p>Format a column or an individual cell, or block of cells.</p> <p>This will have an effect of the "Bermuda Triangle". The text, formulas, numbers remain in the cell, however nothing will be printed in this area of the worksheet if printed.</p> <p> </p>
1. Select the cell you want to hide
2. Hit CTRL+1 (or open format cells dialog from right click)
3. Go to Number tab, select “custom” as the type
4. Type the formatting code as “;;;” without double quotes
5. Press OK and your cell contents are invisible now
1- Select Text and go to Format CELL . Just select a custom format and enter a space. The dialog looks like this
2-2nd option is CONDITIONAL formatting
I like your way. Asking then answering ...:)
using this format ;;;