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

Tagged with

#row zero
#natural language processing for spreadsheets
#Excel alternatives for data analysis
#generative AI for data analysis
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#google sheets
#natural language processing
#Excel alternatives
#zero
#window
#document
#sheets
#option
#blank cell
#extra window
#turn off
#cells
#sheet