Forum Discussion
Keith Thompson
Sep 27, 2017Copper Contributor
Show zero values in cells as checkbox on QAT
Good Afternoon, I have a checkbox on my QAT to check or uncheck to View Gridlines, is it possible to do similar for show or don't show zero values in cells? Regards, Keith Thompson
Raúl Sevilla
Oct 03, 2017Copper Contributor
I agree with Keith. Now hiding zero values takes a lot of clicks: File --> options --> advanced --> display options for this worksheet --> show a zero in cells that have zero value.
It would be great a check box in the View tab of the ribbon like grid lines or formula bar.
Hope Excel developers take it into account.
Thanks
SergeiBaklan
Oct 03, 2017MVP
Raul, more people vote on user voice more chances that will be implemented. You already voted https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/12395253-provide-a-quick-option-to-toggle-the-visibility-of, i added my voice. Not a lot so far.