At the risk of appearing rude..........what the heck are you talking about?

What type of "drop down list" are you referring to?

Are you somehow mixing up "Autofilter" with drop down list?

If your data has been filtered and you want to print just the filtered data,
select top left cell then drag to select to bottom right visible cell.

FilePrintAreaSet Print Area.

FilePrint Preview to see how you make out.


Gord Dibben MS Excel MVP

On Thu, 3 Apr 2008 07:12:01 -0700, SMB-URS
wrote:

How do you print a worksheet with a drop down list without the page breaks? I
want the list printed all togeather instead when I go to print the hidden
rows show blanks and breaks the page up.