Data Validation List
I have several lists that I would like to put into drop down boxes. I tried
going to datavalidation and then chose list (and select my list) and no drop down box shows up. This is strange since if I go to a new sheet and do the same thing I can create a list. Any ideas why I can get it to work with my existing sheet? Thanks! |
A couple of thoughts
Make sure that you have the 'In-cell dropdown box checked in the DataValidationSettings tab. In ToolsOptions, View tab, under 'Objects' make sure the 'Hide All' box is not checked. -- HTH RP (remove nothere from the email address if mailing direct) "John" wrote in message ... I have several lists that I would like to put into drop down boxes. I tried going to datavalidation and then chose list (and select my list) and no drop down box shows up. This is strange since if I go to a new sheet and do the same thing I can create a list. Any ideas why I can get it to work with my existing sheet? Thanks! |
I just copied the data in sections to a new sheet... it works then. Strange
since the options you gave were not applicable. "Bob Phillips" wrote: A couple of thoughts Make sure that you have the 'In-cell dropdown box checked in the DataValidationSettings tab. In ToolsOptions, View tab, under 'Objects' make sure the 'Hide All' box is not checked. -- HTH RP (remove nothere from the email address if mailing direct) "John" wrote in message ... I have several lists that I would like to put into drop down boxes. I tried going to datavalidation and then chose list (and select my list) and no drop down box shows up. This is strange since if I go to a new sheet and do the same thing I can create a list. Any ideas why I can get it to work with my existing sheet? Thanks! |
All times are GMT +1. The time now is 02:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com