Conditional print area

G

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!
 
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top