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. 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). The "smart table", which easily "expands" and changes, has helped us to perform our task. 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. Path: «FORMULAS» - «Define Name» - «New Name». Clear the following check boxes: «Error Alert», «Show error alert invalid data entered».Enter a unique name for the range and press OK. If you do not do this, Excel will not allow you to enter new values. To do this, right-click on the name of the sheet and go to the «View Code» tab. Alternatively, press Alt + F11 simultaneously. How to make a drop down list in excel list in google sheets code#Ĭopy the code (just insert your parameters).
0 Comments
Leave a Reply. |