Excel 2007 - drop down list no longer showing
Greetings
Not sure what I did, but the drop down list that I created for data validation is no longer showing. However, still I can only type valid data that is in the list. So the validation part is working, but there is no drop down menu for each applicable cell. I did freeze pane, but removed it. I also read that you have to make all objects visible. How do you do this in 2007?? Any other suggestions? |
Excel 2007 - drop down list no longer showing
In Data Validation, you get an option to show the available list in dropdown or not, you need to re-enable that. Cosmo Kramer;494186 Wrote: Greetings Not sure what I did, but the drop down list that I created for data validation is no longer showing. However, still I can only type valid data that is in the list. So the validation part is working, but there is no drop down menu for each applicable cell. I did freeze pane, but removed it. I also read that you have to make all objects visible. How do you do this in 2007?? Any other suggestions? -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=136150 |
All times are GMT +1. The time now is 01:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com