Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-887258%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-887258%22%20slang%3D%22en-US%22%3EI%20want%20to%20add%20to%20a%20drop%20down%20list.%20I%E2%80%99m%20not%20able%20to%20find%20the%20table%20where%20list%20is%20kept.%20I%20can%20see%20the%20name%20of%20the%20table.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-887258%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-887326%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-887326%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F418326%22%20target%3D%22_blank%22%3E%40Randy59%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EClick%20on%20the%20cell%20containing%20the%20drop-down%20list.%20With%20this%20cell%20selected%2C%20go%20under%20the%20Data%20Tab%20into%20the%20section%20labeled%20Data%20Tools.%20Click%20Data%20Validation.%20Under%20the%20settings%20tab%2C%20you%20will%20find%20the%20source%20of%20your%20list.%20It%20can%20either%20be%20an%20array%20of%20cells%20(i.e.%20%24A%241%3A%24A%2410)%20or%20a%20manually%20input%20list%20(i.e.%20Option%201%2C%20Option%202%2C%20Option%203%2C....).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps!%3CBR%20%2F%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E
Randy59
Visitor
I want to add to a drop down list. I’m not able to find the table where list is kept. I can see the name of the table.
1 Reply

Hello @Randy59,

 

Click on the cell containing the drop-down list. With this cell selected, go under the Data Tab into the section labeled Data Tools. Click Data Validation. Under the settings tab, you will find the source of your list. It can either be an array of cells (i.e. $A$1:$A$10) or a manually input list (i.e. Option 1, Option 2, Option 3,....).

 

I hope this helps!
PReagan

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
Need to extract values from named cells (Get and Transform)
JEMagnussen in Excel on
23 Replies
!SPILL error with SUMIFS formula
Dzung Vu in Excel on
18 Replies