View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default drop-down lists print on a separate page in excel

If you want to print only part of your worksheet, you can set a Print Area:
Select the cells that you want to print
From the File menu, choose Print Area Set Print Area

If you want the lists on an invisible page, use a named range as the
source, as described he

http://www.contextures.com/xlDataVal01.html

To hide the sheet that contains the lists:
Select the sheet that you want to hide
From the Format menu, choose Sheet Hide

Kayh2 wrote:
I have created drop-down lists in an Excel spreadsheet. When I do the print
preview, there are extra sheets that seem to hold the drop-down formatting.

I heard I can do something on an invisible page that will store the
drop-down lists and not print. Is this true? Is there a way to do this?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html