1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Zero showing in new window

Hello! Sorry if this is a stupid question. When I open an extra window for my document, the sheets in the new window looks messy with lots of «0» where there is a blank cell in the document. I know where to find the «put a zero in cells with zero value» option, so I can turn it back off, but I have to do this for every sheet. Is there a way to just open a new window without the zero option being ticked? English is not my first language, so apologize if something is explained badly.

submitted by /u/IcyLingonberry2151
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article