I have a table column that has data validation applied. It was working fine for a while, but now all of the entries are repeated – as in, if the option selected from the dropdown is "Per Diem," Excel displays "Per DiemPer Diem" in the cell. The formula bar shows the single version when the cell is selected. Is this a bug? Saving/restarting Excel does not clear the problem. Nor does zooming in/out, scrolling around, recalculate, or anything else.

Here is a link to a screenshot, since I cannot post images directly.


I had Format Cells \ Alignment \ Horizontal set to Fill.

Sorry, folks...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.