The values displayed in the cells of Microsoft Office Excel spreadsheets are often derived from the formulas written in them. The result of calculations can be zero value, which is undesirable to show in the cell. Zeros do not improve the overall readability of the results, especially if formulas display text rather than numeric values in other cells of the column. There are several ways to solve this problem.
It is necessary
Tabular editor Microsoft Office Excel 2007 or 2010
Instructions
Step 1
To disable the display of zero values in all cells of an open sheet of an Excel document, use one of the settings in the general settings of the spreadsheet editor. These settings are opened through the main menu - in the 2010 version, click on the "File" button to access it, and in the 2007 version, the round Office button is intended for this. Click on the menu item "Options" (version 2010) or click the button "Excel Options" (version 2007).
Step 2
Select the "Advanced" section from the list and scroll through the list of settings to "Show options for next sheet". Uncheck the box next to Show zeros in cells that contain zero values and click OK.
Step 3
Another method allows you to hide zero values not in the entire sheet, but in an arbitrarily selected group of cells. Select the required area of the table and click the selection with the right mouse button. In the pop-up menu, select the "Format cells" line, and in the left column of the window that opens, click on the bottom line - "All formats".
Step 4
In the field under the "Type" label, enter the following sequence of characters: "0; -0;; @" (without quotes). If non-zero values of the selection should be displayed with a certain number of decimal places, after each zero in this entry, add the corresponding number of zeros, separating them with a comma. For example, to set the precision to hundredths, this record should look like this: "0, 00; -0, 00;; @". Then click OK and the zeros will no longer be displayed.
Step 5
The third method does not remove zero values, but paints them in the background color of the cell and thus makes them invisible. This method uses conditional formatting - select the required column or set of columns and click on the button with this name in the "Styles" group of commands. In the drop-down list, go to the "Cell selection rules" section and select the "Equal" line.
Step 6
In the left field of the form that appears, enter zero, and in the list of the right field, select "Custom Format". The "Format Cells" dialog will open, on the "Font" tab of which you need a drop-down list below the "Color" inscription - open it and in the color table select the shade of the cell background (usually white). Click OK in both open dialogs and the task will be completed.
