close

Login to Excel-King.com

Please use the login boxes below to log in to my webpage. You need to login in i. e. to make sure you can post to the forums.

Log in here!

About the author

Image of Philipp Kowalski

Philipp Kowalski is a self-taught Excel-lover, project manager and blog-owner. Besides developing "beautiful" solutions in MS' premier spreadsheet tool, he loves his fiance, his cats and surfing the net. He is CEO and owner of Inservo IT, the company behind Excel-King. He's also available on Twitter and YouTube. If you like this website, please leave a comment. If you want to know more visit the forums or look into the about section of this website.

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+1 or right-click and choose Format cells.
  • In the Number tab of the occuring dialog box select the last entry from the list: Custom.
  • Now enter three semicolons ";;;" in the Type text box and click OK. 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)


Administrator
Written on Tuesday, 05 January 2010 00:00 by Administrator

Viewed 396 times so far.
Like this? Tweet it to your followers!

Rate this article

(0 votes)

Latest 'tweets' from Phil Kowalski

  • @jonstank hopefully you mean the tv series ;-) Link Monday, 08 March 2010 09:13
  • RT @happymakernowco Choose Happiness with Gratitude | Happy Maker Now http://bit.ly/cQgPki Link Sunday, 21 February 2010 05:12
  • RT @tweetmeme A Day Through the Eyes of a Blind Woman http://is.gd/7GTLq don't always take everything for granted!! Link Sunday, 21 February 2010 04:47
  • Spinning images http://is.gd/8ARak Link Wednesday, 17 February 2010 11:04
  • How does your Excel look like? http://is.gd/8vpph Link Tuesday, 16 February 2010 08:14

Add comment


Security code
Refresh

Sign up for updates

Receive the newest blog posts directly into your inbox!

Please note, that all fields are required.

First Name
Invalid Input
Family Name
Invalid Input
Email
Please enter your email address to receive our newsletter.

Please tick the check box to make sure, that you get the newsletter.

Get my VLOOKUP mini series as PDF for FREE as a little Thank You for signing up!

Sharing is caring

Facebook Twitter Digg Delicious Stumbleupon Google Bookmarks RSS Feed 

Tweet, Tweet...

Click the little blue friend to follow Phil on Twitter!

Advertisement

Create Excel dashboards quickly with Plug-N-Play reports.