[Tuts] Share 3 ways to hide a value of zero in Excel - Blog of knowledge sharing

    Note: Please read the article carefully before proceeding! If in the process of using you encounter any errors, such as broken download links, slow loading blog, or unable to access a certain page on the blog ... then please inform me here. Thanks!

    As you all know, number 0 only exists in Excel file through a certain calculation result. However, it does not support anything in your calculation, but also contributes to make our data more gloomy 😀

    Therefore, to identify the source of the lack of such positive. Today I will share with you 3 ways to hide a value of 0 in Excel the fastest.

    Okey, we will go into the detailed tutorial now!

    Read more:

    Method # 1. Remove zero values ​​with Format Cells

    + Step 1: First you open the Excel file to be processed. Here you select / highlight the data to be hidden 0 => Then right click and select Format Cells.

    Excel-3-way-in-position-0-in-1 (1)

    + Step 2: Dialog box Format Cells opens => here you switch to tabs Number => and select Custom => then enter the command line 0;-0;;@ on item Type => Then press OK.

    Excel-03-excel-in-excel (2)

    + Step 3: Immediately, the results are equal 0 Excel worksheet has been hidden as shown below.

    Excel-03-excel-in-excel-(-3)

    Method # 2. Eliminate a value of zero with Conditional Formatting

    + Step 1: Similar to how to filter numbers 0 In Method 1, you also need to create a selection for the worksheet value => and then click Conditional Formatting => and select New Rule.

    Excel-03-excel-in-excel (4)

    + Step 2: Dialog box New Format Rule appears => here you click Format only cells that contain.

    Excel-03-excel-in-excel-format (5)

    + Step 3: And in the next dialog, set it up in the section Format only cells with respectively:

    • Value Cells
    • equal to
    • And set the value to is 0 same picture

    => Then continue to press Format..

    Excel-03-excel-in-excel-(-6)

    + Step 4: Then open the tab Font at the dialog box Format Cells, you set Color is the moon color => and click OK to apply.

    Excel-03-excel-in-excel (7)

    And finally we get the results as shown below.

    Excel-03-excel-in-excel-(-8)

    Method # 3. Automatically remove zero values ​​right on the Sheet

    Different from the two ways of filtering values ​​(number 0) as above, with the number filtering method 0 On the Sheet you will only need to set once and from the next onwards when entering additional values ​​to return numbers 0 In Sheet, Excel will automatically filter the value by 0 that does not take time to format each piece of data.

    + Step 1: You click on the menu Excel-03-excel-in-excel (9)

    => And select Options.

    Excel-03-excel-in-excel (10)

    + Step 2: Dialog box Options opens => here you switch to tabs Advanced => and then scroll down to the item Display options for this Wooksheet => and deselect at Show a zero in cells that have zero value.

    => Then press OK to set hidden values ​​equal to 0 on Sheet.

    Excel-03-excel-in-excel-(-11)

    # 4. Epilogue

    Okay, so I just gave you very detailed instructions 3 ways to hide zero values ​​in Excel Alright then.

    And here, my article would like to pause. Hope this tip will be helpful to you. Good luck !

    CTV: Luong Trung - Blogchiasekienthuc.com

    Note: Was this article helpful to you? Do not forget to rate the article, like and share it with your friends and relatives!

    Không có nhận xét nào