Sometimes you might not want zero (0) values showing on your worksheets, sometimes you need them to be seen. Whether your format standards or preferences call for zeroes showing or hidden, there are several ways to make it happen.

Hide or display all zero values on a worksheet

Click File -- Options -- Advanced.

Under Display options for this worksheet, select a worksheet, and then do one of the following:

To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.

To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.

--------------------------------------------------------------
Hide zero values in selected cells

These steps hide zero values in selected cells by using a number format. The hidden values appear only in the formula bar and are not printed. If the value in one of these cells changes to a nonzero value, the value will be displayed in the cell, and the format of the value will be similar to the general number format.

Select the cells that contain the zero (0) values that you want to hide.

You can press Ctrl+1, or on the Home tab, click Format -- Format Cells.

Format Cells on the Home tab

Click Number --- Custom.

In the Type box, type 0;-0;;@, and then click OK.

------------------------------------------------------------------------------------------------------
► Official Website
[ Ссылка ]

► SOCIAL MEDIA
Twitter : [ Ссылка ]

► Business Inquiries ONLY
FTC Legal Disclaimer - Some links found in the description box of my videos may be affiliate links, meaning I will make commission on sales you make through my link. This is at no extra cost to you to use my links/codes, it's just one more way to support me and my channel! :)

CONTENT DISCLAIMER
This video is only made for educational and entertainment purposes, so please don’t misuse it. As well as only follow the instruction, visual or verbal on the video at your own risk, we will not be held responsible for any loss or damage. As a part of the YouTube Community, we have not used or recommended using anything against the will of YouTube TOS. As well as we are not used or recommend anything illegal, harmful or dangerous in this video. Thank you

свернуть