Remove zero value from excel worksheet

You've just copied a

formula down a column, and now you have blocks of cells containing 0.00 or

0.00%. You could go back and delete the formulas from those particular cells, but

an easier method would be to change the worksheet to avoid displaying or

printing the zero values.

To do so, follow these steps:

 

1. Go
   
   to Tools | Options.



2. Click
   
   the View tab.



3. Under
   
   the Window Options section, clear the Zero Values check box.



4. Click
   
   OK.

{tipsource}TechRepublic{/tipsource}