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.
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”.