cell givin optional values to use
 

I have received a file in which some cells are giving an option(list) with
scroll.

cell givin optional values to use
 

Those drop downs are part of the Validation tool on the Data menu. These
cells have been configured with a List type validation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"HASSAN SHAREEF" <HASSAN wrote in message
...
I have received a file in which some cells are giving an option(list) with
scroll.

cell givin optional values to use
 

Greetings,
Thank you for your response. The cell is not showing any formula in it.
Please help me to do it on my own.
REgards

"Chip Pearson" wrote:

Those drop downs are part of the Validation tool on the Data menu. These
cells have been configured with a List type validation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"HASSAN SHAREEF" <HASSAN wrote in message
...
I have received a file in which some cells are giving an option(list) with
scroll.

cell givin optional values to use
 

Thanks, Now I can do it my self.

"Chip Pearson" wrote:

Those drop downs are part of the Validation tool on the Data menu. These
cells have been configured with a List type validation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"HASSAN SHAREEF" <HASSAN wrote in message
...
I have received a file in which some cells are giving an option(list) with
scroll.