Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default cell givin optional values to use

I have received a file in which some cells are giving an option(list) with
scroll.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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.


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to list what references any givin hyperlink in excel dijimajik Excel Discussion (Misc queries) 0 September 24th 07 09:34 PM
Optional hyphen? Eric Excel Discussion (Misc queries) 4 October 19th 06 01:31 AM
Optional Linking Vin81 Excel Discussion (Misc queries) 0 February 21st 06 12:56 AM
how to do a Vlook up givin two conditions Gabriela Excel Worksheet Functions 1 December 1st 05 02:20 AM
format optional parameter compound Excel Worksheet Functions 0 September 26th 05 10:55 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"