![]() Clear the following check boxes: «Error Alert», «Show error alert invalid data entered».Enter a unique name for the range and press OK. Path: «FORMULAS» - «Define Name» - «New Name». Now let's make it possible to enter new values directly into the cell with this list and have data automatically added to the range. The "smart table", which easily "expands" and changes, has helped us to perform our task. Here is our table with a list on one sheet: In the «Source:» field, write the following function: Open the parameters of the «Data Validation» tool (the path is described above). Put the cursor on the cell where the drop-down list will be located.That is, you need to select a table style with a header row. In our example, the header is cell A1 with the word «Trees». For solving our task, design does not matter. Find the «Format As Table» tool in the main menu. Highlight the range for the drop-down list.If changes are made to the available range (data are added or deleted), they are automatically reflected in the drop-down list. It is necessary to make a drop-down list with values from the dynamic range. Drop-down list with data lookup in Excel Assign a name for a range of values and enter the name in the «Source:» field.Īny of the mentioned options will give the same result. ![]() Specify a range of cells with a list as a source.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |