Hide Zero Values in Excel 2010

Question: How can I hide zero values in Excel 2010?  I used to be able to hide zero values in Excel 2003.  I can’t seem to find out how to do the same in Excel 2010.

Answer:
Go to File->Options.   Then go to the Advanced, scroll down the right side of the dialog and look for the “Display options of this worksheet” section.  Uncheck the “Show a zero in cells that have zero value”.

This entry was posted in General, How To and tagged . Bookmark the permalink.



5 Responses to Hide Zero Values in Excel 2010

  1. Elizabeth Darlington says:

    I know how to hide zero values in Excel spreadsheets, but I’d prefer to make this the default option and cannot see any way of doing so. Can you help?

    • RAJ NAG says:

      you can create a blank spread sheet file with all default settings you want like, zero suppression, negatives to with in brackets etc., and save as book.xlsk in \programmfiles\microsoftoffice\microsoft14\xlstart folder.. when even you start new spreadsheet it starts with this default settings

      all the best

  2. Robert says:

    Thank you just the answer I needed

  3. victor Raj says:

    Thank you

  4. James says:

    Thanks for the great help. Too bad MS office help is totally worthless with simple questions like this.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>