u/IcyLingonberry2151

▲ 3 r/excel

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.

reddit.com
u/IcyLingonberry2151 — 20 hours ago