| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the Options to View Zero Values to be off always
i always want the zero values to be set to where they never show. at present
i have to click this off every worksheet i have or start. is there anyway to do this globally so that this is not an issue? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set the Options to View Zero Values to be off always
Hello
You may consider creating an excel template (BOOK.XLT) with this option set to off and then place the tempate into the excel startup folder. HTH Cordially Pascal "ydfoley" a écrit dans le message de ... i always want the zero values to be set to where they never show. at present i have to click this off every worksheet i have or start. is there anyway to do this globally so that this is not an issue? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I set the Options to View Zero Values to be off always
How do I place the tempate into the excel startup folder?
"ydfoley" wrote: i always want the zero values to be set to where they never show. at present i have to click this off every worksheet i have or start. is there anyway to do this globally so that this is not an issue? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Modify The XML View Options | New Users to Excel | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| View of x-axis values | Charts and Charting in Excel | |||
| How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
| How do I set Save Options? | Excel Discussion (Misc queries) | |||
Hybrid Mode
