Excel Tips No 4 : Disapear Zero in Your Table View

This free microsoft excel tips no 4 is telling to Disapear Zero in Your Table View. Sometime zero value in our table display make the table become crowded, and disturb our view to analize the table. Here is the step you can do to disapear the zero value display




1. Block the table area you want to disapear the zero value.
2. Click Right mouse and select Format Cell
3. In Category Click Customize
4. In Type type #
5. Click OK

Or You can view the setting display below