Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 27th 10, 01:19 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1
Default drop down list

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   Report Post  
Old January 27th 10, 01:29 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default drop down list

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   Report Post  
Old July 7th 21, 08:26 AM
Member
 
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default Drop down List!

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
drop down list based on other drop down list pick Ruth Excel Discussion (Misc queries) 1 August 25th 09 04:12 PM
Drop down list dependant on previous drop down list Tenacioushail Excel Discussion (Misc queries) 1 July 1st 08 11:35 AM
Drop down lists that auto create and then filter the next drop down list [email protected] Excel Worksheet Functions 2 September 30th 07 11:53 AM
Drop Down List choice selecting another drop down list CVD0722 Excel Worksheet Functions 3 October 31st 06 01:02 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017