There are various ways of editing drop downs lists in excel.įrom excel ribbon go to formula tab name manager or press ctrl f3 simultaneously. If you have created a named range based drop down box then you can just edit your ranges items and then change the reference to the named range. Change the reference under refers to the box by selecting all the entries you want under your drop down list through collapse dialog icon.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |