Show zero values in cells as checkbox on QAT

[Keith Thompson]

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

[#2]

Hi Keith,

That's in options

[#3]

Hi Sergei, Thanks for your reply, I am aware of the setting in Options but was hoping there was a way to put it on the QAT similar to View Gridlines? Regards, Keith

[#4]

Hi Keith,

To my knowledge from the box that's the only option excluding formatting

https://support.office.com/en-us/article/Display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9e4...

However, you may add macro and assign on button which will do the same. Here is quite old discussion but i guess still actual

https://www.mrexcel.com/forum/excel-questions/444529-show-hide-zero-values-quick-access-toolbar.html or similar one

https://www.sageintelligence.com/tips-and-tricks/sage-intelligence-tips-tricks/2015/05/hide-zero-row...

Google could give much more samples.

[#5]

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

[#6]

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..., i added my voice. Not a lot so far.