How To Keep DropDown From Printing?

  • Thread starter Thread starter PutorTutor
  • Start date Start date
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] | CoName Addr1 Addr2
    Address 1..........................................................|
    Address 2..........................................................|
    ====================================|
    Company Name Company Code [drop-down] | CoCode CoName Addr1 Addr2
    Address 1..........................................................|

    Address 2..........................................................|

    ====================================|

    Thank you
 
PutorTutor,

One way would be to use a custom format = ;;;
this renders the text as invisible. But the validation list will still show
up when the user is in the validation cell (and invisible when another cell
is selected). In fact even with the cell selected - the list will show, the
drop down arrow will show, but the selection will remain invisible.

steve
 
PutorTutor said:
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] | CoName Addr1 Addr2
    Address 1..........................................................|
    Address 2..........................................................|
    ====================================|
    Company Name Company Code [drop-down] | CoCode CoName Addr1 Addr2
    Address 1..........................................................|

    Address 2..........................................................|

    ====================================|

    Thank you
Click to expand...


  • From Excel 2000 Help:
    Hide all values in a cell
    1.. Select the cells that contain the values you want to hide.


    2.. On the Format menu, click Cells, and then click the Number tab.
    Show Me

    3.. In the Category list, click Custom.


    4.. In the Type box, select the existing codes and press BACKSPACE.


    5.. In the Type box, type ;;; (three semicolons).
    The hidden values appear only in the formula bar - or in the cell if you
    edit within the cell - and are not printed.

    Tip To display hidden values again, select the cells, click the Cells
    command on the Format menu, and then click the Number tab. In the Category
    list, click General to apply the default number format. To redisplay a date,
    a time, or values that have a specific number format, select the appropriate
    date, time, or number format on the Number tab.

    Bob L.
 
Back
Top