Printing a worksheet with a Drop Down List

[SMB-URS]

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.

 

[Gord Dibben]

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.

File>PrintArea>Set Print Area.

File>Print Preview to see how you make out.


Gord Dibben MS Excel MVP