I created a P.O. template which had an in-cell dropdown for Company Name using
Data Validation[list]. 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" wrote in message
...
I created a P.O. template which had an in-cell dropdown for Company Name
using
Data Validation[list]. 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" wrote in message
...
I created a P.O. template which had an in-cell dropdown for Company Name
using
Data Validation[list]. 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

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.