This question was asked by a TechRepublic member: This morning I took a call from a coworker who wanted help cleaning up data validation rules in an Excel 2007 spreadsheet she inherited from someone else. I was shocked to find that one of the columns had not one but two arrows for dropdown lists in each cell. The cell location indicator showed D5 as I clicked first one one and then on another dropdown, selecting two different values from lists that were similar but not identical. I used =D5 elsewhere and it returned only one of the values. When I tried to insert a column beside the weird column, I got an error about Excel being unable to move cells beyond the edge of the spreadsheet. (What?) Outcome: The user is starting a new sheet from scratch. Meanwhile I googled and binged and couldn’t find a single shred of evidence of this behavior, let alone an explanation of how it happened or how to fix it. Any ideas?
