Data Validation

djb773

New Member
Joined
Jan 24, 2005
Messages
6
Hi, I am trying to create a spreadsheet for numerous users and giving them the option of 7 possible inputs in certain cells using data validation.

To get the 7 different items i understand that i create a table somewhere else within the workbook and define a name for it. (call this table X)

My question is: I do not want to have this table (x) in the workbook.

Can i create 7 different options for them to enter without having to create this second table (x) in the worksheet. Can i enter a data constant in setting up the data validation using ("") or something else.


David
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
You can, but there is a limit to the amount of text you can enter if you do it this way. If the options you want to include in the list are rather lengthy, you can hit the limit rather quickly.

Select your cell, go to Data/Validation and select 'list' from the dropdown. Instead of entering a range in the source, enter the text you want in the list, separated by a comma.
Ex: If you enter option1,option2,option3 as the source, you will have those 3 options available in your list.
 

djb773

New Member
Joined
Jan 24, 2005
Messages
6
Cheers for the rapid response, couldn't find the answer in the text books

David
 

Forum statistics

Threads
1,148,526
Messages
5,747,211
Members
424,068
Latest member
Salim khamis

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