Forum Discussion
Allie94
May 29, 2020Copper Contributor
How to keep cells blank until data entered in
We have an Excel worksheet set up with formulas in place. Right now, without any data entered, all the columns and rows show zero's. We would like for the cells to remain blank until we enter data ...
SergeiBaklan
MVP
One way is to apply custom number format like this to the cells
Another way, if zero are not required in entire sheet, you may disable this setting
Allie94
May 29, 2020Copper Contributor