How to replace 0 with blank cells Excel
How to replace or hide cells containing only 0 with blank cells in Microsoft Excel
Navigate to the 'Find & Replace' option found in the ribbon and enter 0 in the entry for 'Find what' and a blank space for the entry 'Replace with'. Make sure to also tick the box that requests to 'Match entire cell contents'