Drop down list

J

justineb

New Member
Joined
Mar 9, 2009
Messages
2
Hi
I'm using Excel 2007 and have forgotten how to create a drop down list. :(

Can anyone help?

Thanks!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
J

Jeshua

New Member
Joined
Jan 13, 2009
Messages
21
I'm not sure about 2007 but in 2003 it's under data - validation then from the allow select list and then choose the range of data you want to use in the drop down in the source box. Eg =A1:A50 if the data you want to use is in a1 through a 50
 
Upvote 0
Michael M

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
21,648
Office Version
  1. 365
  2. 2019
  3. 2013
  4. 2007
Platform
  1. Windows
Hi justineb
Welcome to the Board
Do you mean a data validation list.
I don't know about 07 but Data / Validation in other versions will do the trick.
Try the Help menu for Data Validation

Regards
Michael M
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Data validation (drop down)
Replies
1
Views
677
Toadstool
Toadstool
U
  • Question
VBA to copy and paste data from drop down list to multiple ranges in different sheet(backup sheet) and replace existing value.
Replies
1
Views
523
jkevz01
J
N
  • Question
Drop down list to return to default after selecting from drop down
Replies
1
Views
512
DanteAmor
DanteAmor
D
  • Question
Hide Used Items in Drop Down List
Replies
9
Views
887
Peter_SSs
Peter_SSs
C
  • Solved
Different drop down list depending on a cell value
Replies
3
Views
1K
craig2525
C

Forum statistics

Threads
1,195,632
Messages
6,010,812
Members
441,569
Latest member
PeggyLee

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top