How To Keep DropDown From Printing?

P

PutorTutor

I created a P.O. template which had an in-cell dropdown for Company Name using
Data Validation
  • . Upon selecting the company's name, it would then fill
    in the corresponding address info for that company via VLOOKUP. The problem is
    I now deal with many companies which have multiple locations. I've moved the
    drop-down list to the right and added the appropriate fields so that it fills
    in the correct information but I don't want the Company Code drop-down field to
    actually print. I thought there was an easy way to suppress printing for a
    specific cell [object] but I can't seem to find it. Print Area is set so all
    the dropdown data off to the right does not appear.


    --------------------------------Printable
    Area---------------------------------|
    ===========================================
    Company Name [drop-down] | Co
    Name Addr1 Addr2
    Address 1
    |
    Address 2
    |
    ===========================================
    Company Name Company Code [drop-down] | Co Code Co
    Name Addr1 Addr2
    Address 1
    |
    Address 2
    |
    ===========================================

    Thank you
 

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

Top