Printing a worksheet with a Drop Down List

S

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.
 
G

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
 

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

Similar Threads

Hiding rows and printing 1
Printing problems with hidden rows 1
Formatted cell column in drop down list 1
Printing cells continuously 4
use v lookup from a drop down list 5
Dependent drop down dynamic range formula, off sheet. 7
can not see anything in drop down list 1
Using Drop Down List or Combo Box 9

Top