It's easy to edit a drop-down list if it's based on an Excel table, as the table should update automatically with your edits. If you want to edit a drop-down list based on a cell range, named range, ...
The best way to do this is by converting your data to an Excel table. Select your data range (A1:E11), press Ctrl + T, and ...
When something so obvious is available in competitors, even in other Microsoft programs and features, and Excel is only now getting it. When working with Excel, one would expect that pivot tables, ...
Cuireadh roinnt torthaí i bhfolach toisc go bhféadfadh siad a bheith dorochtana duit
Taispeáin torthaí dorochtana