If you want to hide all zero values on the sheet,
Tools -- Options -- [View] tab and clear the checkbox next to "Zero Values"

In Excel 2007, that's "Office Button" -- [Excel Options] -- then
[Advanced] in left pane and scroll down to the "Display Options for this
Worksheet" and clear the box next to "Show a zero in cells that have a zero
value" (obviously a much more efficient user interface <g).

"TerriK" wrote:

I have main data entered on worksheet 1 that I have linked to subsequent
worksheets, however when there is no data on worksheet 1 I get 0's printed in
the data space. How doI eliminate the 0?