G Guest Oct 11, 2007 #1 I have received a file in which some cells are giving an option(list) with scroll.
C Chip Pearson Oct 11, 2007 #2 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)
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)
G Guest Oct 15, 2007 #3 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
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
G Guest Oct 15, 2007 #4 Thanks, Now I can do it my self. Chip Pearson said: 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) Click to expand...
Thanks, Now I can do it my self. Chip Pearson said: 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) Click to expand...