List in cell
 

Thanks for taking the time to read my question.

I wasn't sure which thread to post in. I hope I have chosen the correct one.

I have seen drop down lists on some spreadsheets that were in the cell, not
a regular drop down list. This list shows up when you click on the cell, but
when you move away from the cell, the arrow dissappears and the chosen value
remains. You create a list somewhere else that is the list of values in the
drop down list.

I hope this makes sense.

Brad

List in cell
 

Hi Brad,

See Data | Validation.

Debra Dalgleish has a tutorial at:

http://www.contextures.com/xlDataVal01.html

---
Regards,
Norman



"Brad" wrote in message
...
Thanks for taking the time to read my question.

I wasn't sure which thread to post in. I hope I have chosen the correct
one.

I have seen drop down lists on some spreadsheets that were in the cell,
not
a regular drop down list. This list shows up when you click on the cell,
but
when you move away from the cell, the arrow dissappears and the chosen
value
remains. You create a list somewhere else that is the list of values in
the
drop down list.

I hope this makes sense.

Brad

List in cell
 

In Excel from the main menu select Data- Validation -List...

You can enter values separated by comas or you can select a group of cells.
--
HTH...

Jim Thomlinson


"Brad" wrote:

Thanks for taking the time to read my question.

I wasn't sure which thread to post in. I hope I have chosen the correct one.

I have seen drop down lists on some spreadsheets that were in the cell, not
a regular drop down list. This list shows up when you click on the cell, but
when you move away from the cell, the arrow dissappears and the chosen value
remains. You create a list somewhere else that is the list of values in the
drop down list.

I hope this makes sense.

Brad

List in cell
 

It is called Data Validation. Good tutorial at
http://www.contextures.com/xlDataVal01.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brad" wrote in message
...
Thanks for taking the time to read my question.

I wasn't sure which thread to post in. I hope I have chosen the correct
one.

I have seen drop down lists on some spreadsheets that were in the cell,
not
a regular drop down list. This list shows up when you click on the cell,
but
when you move away from the cell, the arrow dissappears and the chosen
value
remains. You create a list somewhere else that is the list of values in
the
drop down list.

I hope this makes sense.

Brad

List in cell
 

Perfect!

If I only had a dollar for every time I went to data validation thinking it
had to be that, but not seeing how to make it happen....

Thanks,

Brad

"Jim Thomlinson" wrote:

In Excel from the main menu select Data- Validation -List...

You can enter values separated by comas or you can select a group of cells.
--
HTH...

Jim Thomlinson


"Brad" wrote:

Thanks for taking the time to read my question.

I wasn't sure which thread to post in. I hope I have chosen the correct one.

I have seen drop down lists on some spreadsheets that were in the cell, not
a regular drop down list. This list shows up when you click on the cell, but
when you move away from the cell, the arrow dissappears and the chosen value
remains. You create a list somewhere else that is the list of values in the
drop down list.

I hope this makes sense.

Brad