What if excel automatically grabs a column of data in data verification and generates a series of drop-down menus?

If you automatically grab a column of data in excel and generate a sequence drop-down menu in data verification.

It can be realized according to the following steps:

1. Enter data in the column to be automatically extracted.

2. In the cell where the drop-down menu needs to be generated, click the right mouse button and select Data Validation.

3. In the Data Validation dialog box, select the Series tab, and then enter the following formula in Source:

=OFFSET($A$ 1，0，0，COUNTA($A:$A)， 1)

Where $A$ 1 is the starting cell of the data column, and COUNTA($A:$A) is the number of non-empty cells in the data column.

4. Click OK to generate the drop-down menu.

5. If the data in the data column changes, the drop-down menu will be updated automatically.