Hi, i don't remember this being as difficult as it's proving to be.

I have a spreadsheet w/ about 100 rows. I want to filter it down to show only the rows containing my particular criteria. So I filter the list down using auto filter and i have a screen with about 10 rows now. i want to print this on a single page. I go to print and I get like 10 pages each with a single row on them, some are even blank! how do i print this filtered list so it looks like my screen: 1 single page with 10 consolidated rows on it?

thank you very much in advance for your help!