Cannot Insert Column
 

Hi!
I am not able to inset coulmn. Whenever I try to inset a colum in the
particular sheet the below message is displayed:

TO PRVENT POSSIBLE LOSS OF DATA, MICROSOFT OFFICE EXCEL CANNOT SHIFT
NONBLANK CELLS OFF THE WORKSHEET.

TRY TO LOCATE THE LAST NONBLANCK CELL BY PRESSING CTRL+END, AND DELETE OR
CLEAR ALL IN CELLS BETWEEN THE LAST CEEL AND THE END OF YOU 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.

I am not able to figure out the message. Please help me.

Thanking you.

Cannot Insert Column
 

You have data in the last column. DELETE the unused columns, SAVE and try
again.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"deepak" wrote in message
...
Hi!
I am not able to inset coulmn. Whenever I try to inset a colum in the
particular sheet the below message is displayed:

TO PRVENT POSSIBLE LOSS OF DATA, MICROSOFT OFFICE EXCEL CANNOT SHIFT
NONBLANK CELLS OFF THE WORKSHEET.

TRY TO LOCATE THE LAST NONBLANCK CELL BY PRESSING CTRL+END, AND DELETE OR
CLEAR ALL IN CELLS BETWEEN THE LAST CEEL AND THE END OF YOU 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.

I am not able to figure out the message. Please help me.

Thanking you.