Sep 26 2017 11:37 PM
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
Sep 27 2017 02:56 PM
Sep 28 2017 03:09 AM
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.
Oct 03 2017 08:39 AM
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
Oct 03 2017 09:18 AM
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.