Ask Experts Questions for FREE Help !
Ask
    mitank's Avatar
    mitank Posts: 8, Reputation: 1
    New Member
    		  
    #1

    Nov 24, 2008, 03:21 AM
    SpreadSheet Printing
    I am using Excel 2007
    I have number of Items in my dropdown list and I need to take a print out of every item from the list.

    Is there any way to give just one print command and the entire list gets printed one by one instead of selecting each item separately and giving a print command.
    colbtech's Avatar
    colbtech Posts: 748, Reputation: 66
    Senior Member
    		  
    #2

    Nov 24, 2008, 06:17 AM

    I presume your dropdown list is in a hidden column? Just unhide that. Would that be OK?
    mdosh01's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
    		  
    #3

    Nov 25, 2008, 06:18 AM

    Assuming the dropdown list is created the same in Excel 2003, it exists somewhere in your workbook. In the menu bar, go to "Data" then "Validation...". Click on the "Settings" tab. In the "Source" box you will see something like "=$h$4:$h$17". This is where the dropdown list is located. Go to that cell range and highlight those cells. Then go to "File", "Print" and in the "Print what" section, click the "Selection" radio button.

    You will need a macro if you want to provide a user friendly method for printing this information.

    I hope I have understood your problem correctly. Note that Excel 2007 may have slight variations to the above.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Spreadsheet link [ 3 Answers ]

How to link one spreadsheet with another, so when entering data in one spreadsheet This data affect the another ones?

Spreadsheet formula [ 5 Answers ]

How do you use { and } formula in Index, as when I use { or } the formula gives error

I cannot save my spreadsheet [ 2 Answers ]

I have had this worksheet for 6 months and I have been building on it every couple of days today it would not allow me to save it, says memory is full ? This unit has very little on the hard drive and very little on he share drive I use o take back and forth between computers. The only...

Excel Spreadsheet [ 1 Answers ]

I need a macro or something for a website that has a excel spreadsheet. My client has a excel spreadsheet out on a website. They have invoice # on the excel spreadsheet and want to be able to scan the invoice and have it linked to the invoice on the website so clients can see the scanned document....

No spreadsheet [ 4 Answers ]

I have a new computer with windows vista. There is no spreadsheet with it like there used to be on computers. Is there a free way to get a spreadsheet system in my computer. I use spreadsheets some but not enough for me to buy anything to get it to work.

View more questions Search