List in Excel

G

Guest

I have som headlines. I would like that in some cells you have to choose
between theese headlines. I have tried to use the "insert list", but i
doosn't do what I need...
 
B

Bondi

Thomas said:
I have som headlines. I would like that in some cells you have to choose
between theese headlines. I have tried to use the "insert list", but i
doosn't do what I need...

Hi Thomas,

Maybe you can use the Validation List feature

If you have your list of headlines in a column. Highlight the cell
where you want the list. Then go to Data -> Validation.. In Validation
Criteria under Allow chose List. In Source chose the range with the
list of headlines then press OK.

This will give you a dropdown in the cell

Regards,
Bondi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top