Forum Discussion
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
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
Hi Keith,
To my knowledge from the box that's the only option excluding formatting
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
Google could give much more samples.
