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

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 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

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