how to create a drop down list without a pre-formed range of cell.

A

Ahmad

I need to create a cell with possible drop down list without a pre-formed
range of cell
 
R

Ron Coderre

So.....the source of the dropdown list would be....what?

Can you give more details about your situation?

***********
Regards,
Ron

XL2002, WinXP
 
G

Gord Dibben

Data>Validation>List.

In Source dialog just type your comma separated list.

john,bill,pete,gord,ahmad


Gord Dibben MS Excel MVP
 
Top