inserting a column

[Guest]

I wonder if you can help? I have created a spreadsheet on which I have been
able to insert columns until now. Now when I go to insert a column I get the
message -

"To prevent possible loss of data Excel cannot shif nonblank cells off the
work sheet.

Try to delete or clear the the 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."

However, I have done both of these and I still get the same error message
all cells at the end of the sheet are clear so there is no data to loose.

I have tried to copy the data to a new sheet and start again but this also
fails.

I would be most appreciative if anyone can help in any way or even point me
in the right direction.

Kindest regards

Neil Brown

 

[Guest]

Hi Neil,
Excel is thinking that there is data where there is none. You can't just
delete the data, you usually need to actually delete the "blank" empty
columns to the right of your data.
If that doesn't work you will probably have to reset your last cell
Try:
http://www.mvps.org/dmcritchie/excel/lastcell.htm

 

[Frank Kabel]

Hi
- select the columns to the right and delte these columns (not only the
data but the columns itself)
- goto cell A1 AND save your file

now try again