Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I am trying to create a drop down list for inventory locations, like tool
crib, shed, yard, etc. How do I go about creating one. -- Adam Gould |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi
Look into Debra web has excellent explanation and examples http://www.contextures.com/xlDataVal01.html http://www.contextures.com/xlDataVal13.html#Create http://www.contextures.com/xlDataVal02.html "Adam gould" wrote: I am trying to create a drop down list for inventory locations, like tool crib, shed, yard, etc. How do I go about creating one. -- Adam Gould |
#3
![]() |
|||
|
|||
![]()
Hello!
You can make a drop down list by: 1) Highlight the cell where you want the list to show up 2) Click data, then validation 3) Allow list 4) Then designated the row/column where the information of the drop down list will come from Voila. You have your own drop down list. For more tips on excel and financial models, you can check this out. Hope this helps! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |