I misread your question initially and told you to do exactly what you're
doing now.
You have a couple of options for toggling the viewing of zero values without
going through Tools | Options.
Easiest way is to probably record 2 macros; 1 recording while using Tools |
Options to hide zero values and a second one to display them. Assign
shortcuts to them and use those shortcuts to toggle zero value display when
you want to.
Another, more complex, way would be to designate a cell to hold a "flag"
value (0 or 1) and use that as part of an IF(AND()) formula to hide/display
zero values.
Let's say you choose cell A1 as the 'flag' cell: when it has a 0 in it, you
do not want to see zero values, when it has something other than 0 in it, it
means you do want to see them.
Now, down in another cell you have a formula like =D5+D6 which may or may
not have a result of zero. If you set up the formula like this in that cell:
=IF(AND(A1=0,D5+D6=0),"",D5+D6)
But as I said, that's a little more complex and requires you to change all
existing formulas and to remember to 'wrap' any future formulas with the
IF(AND()) trap.
