radio button? menu box?

**rookie37** · 11-19-2009, 07:19 PM

I need something and I don't even know what it's called

I write "northern hemisphere" or "southern hemisphere".

I'd like a cell that will select one of these by a mouse click instead of having to type out the whole thing. Not only would it be a time saver, it will reduce the errors because then I only have those two choices.

**rwgrietveld** · 11-19-2009, 07:20 PM

Make a validation list with both strings.

**Palmetto** · 11-19-2009, 07:26 PM

See this link for help on the Data Validation Basics

**rookie37** · 11-19-2009, 08:04 PM

Originally Posted by Palmetto

See this link for help on the Data Validation Basics

If my response or solution was helpful, you can add to my reputation by clicking the blue scales icon in one of my posts in this thread. Thanks.

I did add to your reputation. Thank you for your help. Now how do I put 'Solved' on this thread?

**Palmetto** · 11-19-2009, 08:20 PM

Now how do I put 'Solved' on this thread?

To mark your thread solved do the following: - Go to the first post - Click edit - Click Advance - Just below the word "Title:" you will see a dropdown with the word No prefix. - Change to Solve - Click Save