Conditional print area

[Guest]

Hi there.
I have a long document with +/- 400 rows of information, mostly text. I need
to print the document and exclude/hide about 100 of those rows, based on
their content. Is there some way to conditionally hide those rows instead of
manually hiding each before I print them?
Thanks!

 

[Don Guillett]

data>filter>autofilter>custom>not equal to>yourvalue

 

[Guest]

Hi,

If you want to exclude certain rows then select FILE then click on PAGE
SETUP, then a dialouge box will appear, there will be 4 tabs, select the tab
that says SHEET, and then direclty under that tab in the left hand side it
will say "PRINT AREA"

and then there will be like an area where you can enter something but at the
end of that field to the right before the PRINT button is a "small icon"
which you can click and then you can select the area or select multiple areas
to print,

(To Select multiple areas you choose one are and hold the "CTRL" button on
ur keyboard and select more areas.you can click on a column/s to print that
entire column, the same with the rows.) this way you can choose your areas to
print.