Having Trouble Inserting a Column

E

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.
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top