Hide Zero Values in Excel | Make Cells Blank If the Value is 0

Toggle fullscreen Fullscreen button

Sharing buttons:

hello and welcome to this excel tips

video I am so miss bunsall from Trump

Excel comm and in this video I'm going

to show you how to hide zeros in cells

in exam now here I have a data set and

you can see there are a couple of cells

that have the zero value in it and in

this video I'm going to show you a

couple of ways to hide these zeros and

one method to remove these zeros now

before I show you those methods let me

quickly tell you the difference between

hiding a zero and removing a zero when

you hide a zero from a cell that value

is not visible to you but it's still

there in the cell so if I hide this zero

value here the cell may appear blank but

the value would still be there so if I'm

using these this range or this cell in

any calculation it would take the cell

value as 0 but when I remove this zero