Error adding column in excel

[PennyB]

I get the error message

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

Try to delete or clear cells to the right and below your data. Then 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."


Is there a way round this?

Penny

 

[onedtent]

Excel thinks you have something in last column IV.

highlight all the columns that don't have data in 'em and go to Edit, Clear, All