Drop down entries in table disappear when selected

rothbe · #1 04-20-2015, 11:24 AM

I created a table with a variety of down down box selections for each different column. It was working fine and everyone could complete the form with no issues. Now, all of a sudden, when the drop down box is selected, the choices still appear in the drop down list but when any of them are selected, the result is a blank cell. This is happening for most of the document. Any ideas???

After playing with this some more I was able to adjust display options to show hidden text. That seems to solve this for now but then "why is a drop down box selection considered hidden text"?????

macropod · #2 06-05-2015, 05:04 PM

The problem you describe results from either the cell contents or the Style used for the dropdown text being formatted as hidden; it's not a property of the dropdown itself.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Drop Down Menu to present Selected data in same sheet	awaisdotcom	Excel Programming	1	04-04-2015 12:40 PM
Need macro to fill data from different sheets based on selected item from drop down	skorasika	Excel Programming	1	03-13-2015 11:25 AM
Pivot Table Question- Can the table display in the order the boxes were checked/selected?	blackjack	Excel	0	09-13-2014 08:57 PM
Heading row disappears from table styles when pasted table is selected	andrewballem	Word Tables	2	11-12-2013 05:18 AM
Returning a specific value when item is selected from a drop-down list	J Press	Excel	4	09-10-2012 06:12 AM