| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Zero Values
Hi,
I know I hae done this before a few times. I've done each sheet separately, and al thogether as a group. Yet, for some reason, the option to hide zro values seems to get reset to showing Zero values. I am changing the formatting. So far just the borders as I recall, so why is this option getting reset? Thanks in advance Habib -- www.DynExtra.com A resource for the Microsoft Dynamics Community Featuring FAQs, File Exchange and more Current member count: 40 -------------------------------------------- Share your knowledge. Add your favorite questions and answers Help add questions to this site! We want Your input. -------------------------------------------- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Zero Values
Which option are you referring to, ToolsOptionsView, and the Zero Values
checkbox? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "HSalim[MVP]" wrote in message ... Hi, I know I hae done this before a few times. I've done each sheet separately, and al thogether as a group. Yet, for some reason, the option to hide zro values seems to get reset to showing Zero values. I am changing the formatting. So far just the borders as I recall, so why is this option getting reset? Thanks in advance Habib -- www.DynExtra.com A resource for the Microsoft Dynamics Community Featuring FAQs, File Exchange and more Current member count: 40 -------------------------------------------- Share your knowledge. Add your favorite questions and answers Help add questions to this site! We want Your input. -------------------------------------------- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Zero Values
yes
-- www.DynExtra.com A resource for the Microsoft Dynamics Community Featuring FAQs, File Exchange and more Current member count: 40 -------------------------------------------- Share your knowledge. Add your favorite questions and answers Help add questions to this site! We want Your input. -------------------------------------------- "Bob Phillips" wrote in message ... Which option are you referring to, ToolsOptionsView, and the Zero Values checkbox? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "HSalim[MVP]" wrote in message ... Hi, I know I hae done this before a few times. I've done each sheet separately, and al thogether as a group. Yet, for some reason, the option to hide zro values seems to get reset to showing Zero values. I am changing the formatting. So far just the borders as I recall, so why is this option getting reset? Thanks in advance Habib -- www.DynExtra.com A resource for the Microsoft Dynamics Community Featuring FAQs, File Exchange and more Current member count: 40 -------------------------------------------- Share your knowledge. Add your favorite questions and answers Help add questions to this site! We want Your input. -------------------------------------------- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Zero values bar one | Excel Discussion (Misc queries) | |||
| Hide values | Excel Discussion (Misc queries) | |||
| Hide Zero Values | Excel Discussion (Misc queries) | |||
| Hide all values in a row if value is 0 | Excel Worksheet Functions | |||
| How to hide like values | Excel Discussion (Misc queries) | |||
![HSalim[MVP] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
