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
