Cannot insert columns in a worksheet - gives an error message:
To prevent possible loss of data, Microsoft Office Excel cannot shift
nonblank cells off the worksheet.
Try to locate the last nonblank cell by pressing Ctrl + End, and delete or
clear all in cells between the last cell and the end of your data. The
select cell A1 and save your workbook to reset the last cell used.
Or, you can move the data to a new location and try again.

I have followed the instructions, but no help.
any thoughts???