View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WiFiMike2006 WiFiMike2006 is offline
external usenet poster
 
Posts: 23
Default hiding zero values on all sheets & by default on new sheets

Ok. So how do I set up the default values for workbooks?

Thanks,
Mike

"vttanker" wrote:

Mike,

Go to ToolsOptions. On the View tab there is a checkbox call Zero Values.
If you uncheck the box any zero value will disappear. This will affect any
workbook you open regardless of the previous settings. You can also setup
many other default settings for your workbooks when they open and when you
add worksheets.
--
Tim Murphy


"WiFiMike2006" wrote:

Hello,

In Excel 2003, how can I hide zero values on all worksheets in a workbook,
and how can I set it up so that any new worksheet or workbook created has
zero values hidden?

Thank you,

Mike