Excel has a 'helpful' function - when you insert a new column it adopts the formatting and data validation from the column to the left.

When you insert a cut/copied column that contains its own formatting and dropdowns, the inserted column retains its formatting but still adopts the dropdowns from the column to the left, even overriding the dropdowns that were in the inserted column.

Does anyone know how to stop this from happening, and just let the cut/copied column be inserted and keep its dropdowns?!