how do you print filtered lists?

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!

It sounds to me like you have multiple page breaks inserted into the sheet data. I would recommend removing all page breaks. That should likely resolve the issue.

HTH

Jason