Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Printing a worksheet with a Drop Down List

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Printing a worksheet with a Drop Down List

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop Down List from one worksheet to another Angel V. Excel Discussion (Misc queries) 5 January 21st 08 07:58 PM
Drop Down list from a different worksheet Boo Excel Discussion (Misc queries) 2 January 19th 08 06:46 PM
How do I create a worksheet using a drop down list? TodiHawk Excel Worksheet Functions 2 May 29th 07 09:41 AM
can I ensure a drop down list is used i.e by preventing printing Have a Go Excel Discussion (Misc queries) 1 December 15th 06 04:27 AM
Populating worksheet via a drop down list ! kuansheng Excel Worksheet Functions 4 February 14th 06 05:48 AM


All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"