Todays Quick-Tip is really a very very short one. It's about formatting a value towards invisibility. Sometimes you need values in cells only for calculation purposes and don't want your users to see them.
Hide columns and / or rows is one way, but it's pretty obvious for the user, that there is something missing. There is an easier way to do it: Simply enter your values and after that, give them a custom format.
- Enter the desired values.
- Select the range you want to hide and press
CTRL+1or right-click and chooseFormat cells. - In the
Numbertab of the occuring dialog box select the last entry from the list:Custom. - Now enter three semicolons ";;;" in the
Typetext box and clickOK. Voilà, your entries are hidden.
What does the custom format of ";;;" mean to MSXL? It tells the application to NOT show any number (whether they are positive or negative numbers), no zero-values and no text. Cool, isn't it?
Discuss this blog post in the forums (click the blue button)
