Printing out only rows where certain cells have contents

[Guest]

We have a spreadsheet that has lots of rows in it.

However each time we use it only some of the rows are filled in under one of
the colums. If a row has that particular cell filled in (not null), we want
the row printed out in the report or printout. What is the best way to do
this?

Thanks for your suggestions.

Bryan Bloom

 

[Pete_UK]

What I do in this situation is to make use of a column away from the
print range, let's say column H, and put a formula which is looking at
the column of interest such as:

=A1 (copied down)

This will return a zero if the cell is empty. I have a filter set up
for column H and use Custom ... | Not Equal To | 0 (zero) and this then
hides the unwanted rows.

Hope this helps.

Pete

 

[Guest]

Thanks Pete, I will try this.. Much appreciated.

Bryan

 

[Pete_UK]

You're welcome, Bryan.

Pete

Thanks Pete, I will try this.. Much appreciated.

Bryan