How do i add text to a drop down list

Solved/Closed
Maxi84 Posts 2 Registration date Wednesday February 27, 2013 Status Member Last seen January 21, 2014 - Feb 27, 2013 at 03:07 AM
Maxi84 Posts 2 Registration date Wednesday February 27, 2013 Status Member 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


2 replies

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Feb 27, 2013 at 06:07 AM
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.
0
Maxi84 Posts 2 Registration date Wednesday February 27, 2013 Status Member Last seen January 21, 2014
Jan 21, 2014 at 05:51 AM
It worked thank you
0