Of the three methods, the conditional formatting method is probably the least productive because of the potential to forget it costs can run high with employing formatting tricks. This format is easy to forget and can cause trouble down the road, so choose this method carefully. From the Color dropdown, choose White (or the color that matches the sheet's background).From the second dropdown, choose Equal To.In the top pane, select the Format Only Cells That Contain option.In Excel 2003, choose Conditional Formatting from the Format menu, and skip to step 4.
Click the Home tab and then click the Conditional Formatting option in the Styles group.Select the cells that contain the 0s you want to hide.When you run into an exception, you can use a conditional format as follows: The numeric format shown above will hide literal zeroes and most returned by a formula. To undo this format, simply choose an alternate numeric format for the cells. Hidden 0s will still be visible in the Formula bar, or in the cell, if you edit in the cell. In Excel 2003, choose Cells from the Format menu. Click the Home tab and click the Number group's dialog launcher (the small arrow in the bottom-right corner.Select the cells that contain the zero values that you want to hide.If you want to hide specific zero values, but not all, you can use a numeric format instead: The sheet setting will hide all zero values in the sheet.
0 kommentar(er)
