A ChatGPT AI has proved a conjecture with a method no human had thought of. Experts believe it may have further uses ...
Go to File > Options > Advanced and scroll all the way down to Display options for this worksheet. Uncheck the box next to Show a zero in cells that have zero value, and they'll appear as a blank.