What should I do if Excel table 0 cannot be displayed?
As shown in the picture below, we want to hide the 0 in the excel cell, as shown in the picture on the right.
Recommended: "excel tutorial"
The author is using the office 2007 version, click the "OFFICE button- EXCEL Options - Advanced - Display options for this worksheet - Uncheck "Display zeros in cells with zero values". As shown below:
If the Excel version you are using is version 2003, click "Tools-Options-View-Window Options-Remove the check mark before the zero value"
Note: The setting of this method is for all cells of the current worksheet Make settings.
The above is the detailed content of What should I do if Excel table 0 cannot be displayed?. For more information, please follow other related articles on the PHP Chinese website!