In one column or zeros in random cells in many rows and columns?

The entire row has to have zeros?

Several options depending upon what you mean.

If just one column, you could use DataFilterAutofilter to hide the rows with
zero in that column.


Gord Dibben MS Excel MVP

On Fri, 25 Jan 2008 15:47:01 -0800, Eric wrote:

Does anyone know how to create a worksheet that will automatically hide rows
that have zero values when you want to print?