Having Trouble Inserting a Column

[Elisa]

Hoping someone can help me with this......

In Excel 2003 working in a spreadsheet, I cannot insert a new column. I get
this 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. Then
select cell A1 and save your workbook to reset your last cell used.'

'Or you can move your data to a new location and try again.'

I did try to move the spreadsheet into another blank page and it still did
not work.

 

[reitanospa1]

The problem is that there is a cell in the last column that has
something in it (even a space counts as "something") and Excel is
unwilling to discard that non-empty column by inserting a new one.
Since the [Ctrl]+[End] keystroke takes you to the end of your data,
they are suggesting you try that to determine where you information
ends.

If you delete that last column, you will solve the problem. Note that
there could be all sorts of data in the column, so you should scroll
through it before deleting.