Create category Drop-down list fill item in Excel table

1, in Sheet2, the name of the enterprise by category (such as "Industrial Enterprise", "Commercial enterprise", "individual enterprise", etc.) into different columns, the establishment of a database of enterprise names.

2, select Column A ("Industrial enterprise" name of the column), in the "Name" column, enter the "industrial Enterprise" character, press "enter" key to confirm.

Imitate the above operation, will B, C ... The columns are named "Commercial enterprise", "Individual Enterprise", respectively.

3. Switch to Sheet1, select the column (such as column C) where you want to enter the enterprise category, and execute the data → effectivity command to open the Data Validation dialog box. In the Settings tab, click the Drop-down button to the right of allow, select the sequence option, and in the Source box below, enter "industrial Enterprise", "Commercial enterprise", "Individual enterprise" ... Sequence (separated by commas between the elements), OK exit.

Select the column you want to enter the enterprise name for, such as column D, and then open the Data Validation dialog box, select the series option, and then enter the formula in the Source box: =indirect (C1), OK exit.

4, select the C column any cell (such as C4), click the Right Drop-down button, select the appropriate "Enterprise category" to fill in the cell. Then select the cell in column D (for example, D4) and click the Drop-down button to fill in the cell with the desired enterprise name from the list of enterprise names for the category.

Tip: If you don't need to print the Enterprise category column when you print the report later, you can select the column, right-click, and hide the column by selecting the Hide option.