Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drop Down List from one worksheet to another | Excel Discussion (Misc queries) | |||
Drop Down list from a different worksheet | Excel Discussion (Misc queries) | |||
How do I create a worksheet using a drop down list? | Excel Worksheet Functions | |||
can I ensure a drop down list is used i.e by preventing printing | Excel Discussion (Misc queries) | |||
Populating worksheet via a drop down list ! | Excel Worksheet Functions |