Posted by Richard on September 06, 2001 5:16 PM
I have always been able to add (Insert)columns to my worksheet and now I get a message "To prevent possible loss of data, MS Excel cannot shift nonblank cells off the worksheet. Try to delete or clear the cells to the right and below your data. Then select 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 have alway had data to the right when I did this before. Did I do something to corrupt the file or define the worksheet that is preventing the adding of columns?