Spreadsheet Tips

How to Show Zeroes as Blank Cells in Excel

June 28, 2018
show-zeroes-blank-cells-excel
Sometimes, my spreadsheets get a little messy with too many zeroes. In these cases, it's better to show those zeroes as blank cells instead. Go to the options and uncheck Advanced > "Show a zero in cells that have zero value" to do just that.