Printing only certain rows

G

Guest

Is there a way (custom view, filter, etc) to only print rows in a print area
that have a value greater than x amount in a certain column? For instance, I
have a worksheet that shows all outstanding accounts. Each account has it's
own row (and the sheet has a couple of header rows). One of the columns
shows the total days overdue the account is. However, I only want to print
the header rows and the subsequent rows with account balances greater than 90
days. It seems incredible there is no easy way to do this, but I have been
searching Excel help without any luck.

Thanks
 
D

Dave Peterson

I'd apply data|filter|autofilter to that column.

Then use the dropdown arrow, select custom
and choose "is greater than" and supply the number of days you want

Then print.
Then Data|filter|showall (to see everything again)
 

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