Inserting Columns

[Jim McColl]

I am trying to insert a column on a worksheet and keep
getting the message: : "to prevent possible loss of data
Microsoft Excel cannot shift nonblank cells off the
worksheet".

I am using Excel 2000. I have no protection set and no
merged cells anywhere on the worksheet. It does no matter
where I shift the cell pointer and try to do the insert,
I get the above message. I have used Excel for many
years and have never seen this problem before.

I'm sure there must be something obviouis I am missing,
but have no idea what it could be.

Please help

Thanks

Thanks

 

[PegL]

You can only have columns A-IV in use. If you are using
all those columns, you can't add another column without
losing data. If you're not using all the columns, Excel
thinks you are. Saving should reset the "used" area. If
it doesn't, then you've probably got formula(s) across
all columns, or something similar.

 

[Guest]

-----Original Message-----
You can only have columns A-IV in use. If you are using
all those columns, you can't add another column without
losing data. If you're not using all the columns, Excel
thinks you are. Saving should reset the "used" area. If
it doesn't, then you've probably got formula(s) across
all columns, or something similar.

PegL - Thanks very much for your prompt, and correct
reply.

I am only using up to column Q, but guess I must have
gotten carried away with copying a formula somewhere on
the worksheet. Anyway, I have now managed to clear the
problem thanks to your help.

Regards