nsatn.blogg.se

Whether you use a named range for your drop-down list or a cell range without a name, removing an item from the list works the same way. Your drop-down list automatically updates to include the new list item. Click the checkmark to the left of that field to save your changes and hit “Close.” You can manually adjust the cell references or simply drag through them on your sheet. When the Name Manager opens, select the named range and update the cell references in the Refers To box at the bottom. Go to the Formulas tab and select “Name Manager” in the Defined Names section of the ribbon. However, this will not update the named range to include the additional item. If you use a named range for your list items, you can use the above method to add an item to the list. Optionally, check the box at the bottom if you use the list in more than one place and want to update it throughout.