How to edit my Excel dropdown list

Question

How to edit my Excel dropdown list    I went to Data -  Validation -  Settings  and in that I found the values as  Attribute Brands   What I have to do to edit this

User · Answer

Attribute Brands is a named range that should contain your list items  Use the drop down to the left of the formula bar to jump to the named range  then edit it  If you add or remove items you will need to adjust the range the named range covers

User · Answer

The answers above will work for changing the values   If you want to change the number of cells in your list  e g  I have a list called  revisions  which has 4 items  I now need 7 items  you will find that you can t simply select your list and amend it on the sheet  So   go to your  Formulas  tab  choose  Name Manager   a pop up box will show what is available for editing  Your list should be in it  Select your list and edit the range

User · Answer

Attribute Brands is a named range   On any worksheet  tab  press F5 and type Attribute Brands into the reference box and click on the OK button   This will take you to the named range   The data in it can be updated by typing new values into the cells   The named range can be altered via the  Insert - Name - Define  menu

[excel] How to edit my Excel dropdown list?

Examples related to excel

Examples related to excel-2003