Question

1.
in drop-down box helps you to search only the field or all the current fields in the
entire table​

Answer 1

Answer:

Your question will be shared anonymously with online publishers who may be interested in answering it

Answer 2

Explanation:

I will in this article demonstrate how to use a value from a drop-down list and use it to do a lookup in a dataset or preferably in an Excel defined Table. In other words, this will auto populate other cells when selecting values in a drop-down list.

I will also demonstrate how to create, edit and add values to a drop-down list. There are several kinds of drop-down lists in Excel. Data validation and Combo Boxes. They have their advantages and disadvantages and I will discuss them in this article.