On a separate sheet to where you want the validation to occur, type in A B and C in separate cells. Select those cells, click on Insert-Name- Define and enter a name in the top box (say myList) and click on 'Add'. Go onto the sheet where you want the data to be validated, select the cells and click on Data-Validation, change the 'Allow' to List and in the Source box enter =myList. HTH.
On 2002-04-20 10:09, Galvin wrote:
I want to enter a validation on a cells, the data can only be "A B or C" so how can I do that, I'm a Newb to i'm a bit confused! thank u mike
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.
