Automatically hide rows where a range of cells have the value of z

S

ScottJSP

In my worksheet, many rows in column "a" have a description for the row.
Columns "b" through "e" have formulas that pull numbers from various other
worksheets. Sometimes rows will have the description in column "a" but all
of the values calculated in columns "b" through "e" for those rows will have
a value of zero. Is there a way to automatically hide those rows when I
print the sheet?
 
G

Gord Dibben

Scott

If always B through E are showing zero in some rows, you can Autofilter on
column B.

Data>Filter>Autofilter>Custom>Greater than 0

Print will print only the filtered row.

To automatically do this, record a macro while going through the filtering
steps then stick that code into a Before_Print event.

Gord Dibben Excel MVP
 
Top