Cannot Insert Column

D

deepak

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

Don Guillett

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

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