Show zero values in cells as checkbox on QAT

Question

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?&nbsp;Regards,&nbsp;Keith Thompson&nbsp;

keith thompson · Answer

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

sergeibaklan · Answer

Hi Keith,&nbsp;That's in options

sergeibaklan · Answer

Hi Keith,&nbsp;To my knowledge from the box that's the only option excluding formattinghttps://support.office.com/en-us/article/Display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9e476b03&nbsp;However, you may add macro and assign on button which will do the same. Here is quite old discussion but i guess still actualhttps://www.mrexcel.com/forum/excel-questions/444529-show-hide-zero-values-quick-access-toolbar.html or similar onehttps://www.sageintelligence.com/tips-and-tricks/sage-intelligence-tips-tricks/2015/05/hide-zero-rows-using-excel-functionality/Google could give much more samples.&nbsp;

raúl sevilla · Answer

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 · Answer

Raul, more people vote on user voice more chances that will be implemented. You already voted&nbsp;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.

Forum Discussion

Show zero values in cells as checkbox on QAT

5 Replies

Resources