Refer the below

http://support.microsoft.com/default.aspx/kb/305568
--
If this post helps click Yes
---------------
Jacob Skaria


"evoxfan" wrote:

I tried to copy and insert a columne and got the following error message:

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

Any ideas on how I might be able to correct his and insert my column?

Thanks.