Forum Discussion

rodsan724's avatar
rodsan724
Brass Contributor
Aug 31, 2023
Solved

Excel inserting new column takes on attributes of the column before it

I have a named table in a worksheet. The left most column contains a DataValidation List. When I insert a new column to the left of it with the following, it takes on the same DataValidation List whi...
  • HansVogelaar's avatar
    Aug 31, 2023

    rodsan724 

    Or use the line that you posted, then delete data validation from the newly inserted column.

Resources