How do i add text to a drop down list [Solved/Closed]

Maxi84
Posts
2
Registration date
Wednesday February 27, 2013
Last seen
January 21, 2014
- Feb 27, 2013 at 03:07 AM - Latest reply: Maxi84
Posts
2
Registration date
Wednesday February 27, 2013
Last seen
January 21, 2014
- Jan 21, 2014 at 05:51 AM
Good day


how do i add text to a drop down list i created in excel


See more 

2 replies

Zohaib R
Posts
2421
Registration date
Sunday September 23, 2012
Last seen
July 16, 2018
- Feb 27, 2013 at 06:07 AM
0
Thank you
Hi Maxi84,

From your post, I understand that you created data validation (drop-down list) for a cell and now the Excel Sheet doesn't allow you to add any text to it. Any easy work around is to copy and paste the text from another cell. I use this method, please try this and reply with the results.

Kindly get back if there are any further queries.
Maxi84
Posts
2
Registration date
Wednesday February 27, 2013
Last seen
January 21, 2014
- Jan 21, 2014 at 05:51 AM
0
Thank you
It worked thank you