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

Maxi84 2 Posts Wednesday February 27, 2013Registration date January 21, 2014 Last seen - Feb 27, 2013 at 03:07 AM - Latest reply: Maxi84 2 Posts Wednesday February 27, 2013Registration date January 21, 2014 Last seen
- 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 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen - 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 2 Posts Wednesday February 27, 2013Registration date January 21, 2014 Last seen - Jan 21, 2014 at 05:51 AM
0
Thank you
It worked thank you