Tutorial method for completing data filling in Excel using defined names and data validity

Troubled you are how to let Excel fill the specified data? Don’t worry, PHP editor Strawberry has a solution for you! This tutorial will introduce in detail how to use the define name and data validation functions to easily fill in data and help you improve your Excel skills.

As shown in the figure, there are multiple worksheets in the Excel table, which are employee information tables for each department. There is a column for academic qualifications, so there is no need for everyone to enter it manually. You can use excel data validation (data validation) to do this.

Select the cell range A2:A7 and enter a name in the new name box, for example: education list.

Return to the [Marketing Department] worksheet, select [C2:C11 cell], perform data verification, select [Sequence] in the [Allow] drop-down box, and enter [=Educational Qualification] in the source box List] (the name defined in the first step).

The effect is as shown in the figure:

In the same way, complete the settings of the [Education] column in the [Propaganda Department] worksheet.

The above is the detailed content of Tutorial method for completing data filling in Excel using defined names and data validity. For more information, please follow other related articles on the PHP Chinese website!