| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert a blank column between each column in a data file | Excel Discussion (Misc queries) | |||
| insert row / insert column command buttons | Excel Worksheet Functions | |||
| Insert blank column every other column | Excel Discussion (Misc queries) | |||
| how to insert column between q. | Excel Discussion (Misc queries) | |||
| Insert a row if there is a value in a column in the row above | Excel Discussion (Misc queries) | |||
Threaded Mode
