Drop down. *EASY* question!

[Laura \( '_' \)]

BlankHiya everyone
I was just wondering if anybody could explain something reeeeally easy for
me?
In Excel, I would like a two drop-down features in my columns of my
spreadsheet.
The first one (columnE) with the options 'yes' or 'no'.
The second one (columnD) with a list of names, eg.
Anthony
Peter
Mark
Jonathan

Thankyou for ANY help you can give me!

--
@---}--
Laura.....
Liverpool, England

"Do you know where you're going to?"

 

[Bob Phillips]

Data>Validation, choose a type of list, and then just type the values comma
separated.

--

HTH

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

 

[Roger Govier]

Hi Laura

For the first case, select the cell concerned
Data>Validation>dropdown select List> in white Pane type Yes,No
For second case, create a list of names somewhere on your sheet (or another
sheet). In the small white pane to the left of column A, type Names and hit
Enter. This defines it as a named range.

Select your second cell for dropdown, Data>Validation>List> in white pane
type =Names

Regards

Roger Govier

 

[Laura \( '_' \)]

Right thankyou very much for that.
Just one last thing, I want a column just for times and I want it set out
like hh.ss(am or pm), how could I do this?
Thankyou.

--
@---}--
Laura.....
Liverpool, England

"Do you know where you're going to?"

 

[Bob Phillips]

That is just a format. Go to Format>Cells>Time and choose the format you
like.

--

HTH

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