Adding more options in a drop down list

N

Noel

I would like to add to a drop down list that is in a column of an excel
spreadsheet. I can insert a line and then when I try to add or change the
drop down list, I get the following error:
"THE VALUE YOU ENTERED IS NOT VALID. A USER HAS RESTRICTED VALUES THAT CAN
BE ENTERED INTO THIS CELL."

I received this spreadsheet from a coworker that had created it. I believe
they may have copied the information from another spreadsheet. Is it possible
she brought some protected information with it?
 
G

Gord Dibben

The dropdown list is most likely created through Data Validation and will
limit user to what is on the list.

If you want to type something other than what is in the dropdown you must
uncheck the error alert.

This won't add to the items in the list but will allow you to type something
not on the list.

If you want to permanently add to the list, you must edit the source list
range.

Data Validation>Allow>List>Source.

See where the list comes from then edit that source.


Gord Dibben MS Excel MVP
 
N

Noel

There is no source listed.

Gord Dibben said:
The dropdown list is most likely created through Data Validation and will
limit user to what is on the list.

If you want to type something other than what is in the dropdown you must
uncheck the error alert.

This won't add to the items in the list but will allow you to type something
not on the list.

If you want to permanently add to the list, you must edit the source list
range.

Data Validation>Allow>List>Source.

See where the list comes from then edit that source.


Gord Dibben MS Excel MVP
Click to expand...
 
G

Gord Dibben

If you have a Data Validation dropdown list with items to choose you "must"
have a source for that list.

Either a defined range like =MyList entered in the Source dialog.

Or a comma de-limited list in the Source dialog.

Are you sure you have a DV dropdown list?

When you select the cell does an arrow appear at right side of cell?


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Drop down lists in seperate columns 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Link a text box based on drop down box with four options MS Word 365 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Getting error when adding to an drop down list 1
Error received when trying to add to a drop down list 0
Subcategories in Drop Down List 2

Top