Cannot insert new column in Excel

Error message: "To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet."

Select first unnecessary column -  CTRL+Shift+Right - selects all columns till end.

Press separately magic combination ALT, E, A, A (Clear All content)

Source: wizardofexcel.com