Glutamine83
New Member
- Joined
- May 15, 2003
- Messages
- 6
I have a spreadsheet approx. 50 columns wide, and 300 rows deep, which has a multitude of data in the form of text, numbers, and some simple formulas, mostly sums
however, i want to add a column and every time i highlight a column, right click, and select insert, i get the following message:
"To prevent possible loss of data, Excel cannot shift nonblank cells off the worksheet.
Try to delete or clear the cells to the right and below the 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."
Any thoughts???
however, i want to add a column and every time i highlight a column, right click, and select insert, i get the following message:
"To prevent possible loss of data, Excel cannot shift nonblank cells off the worksheet.
Try to delete or clear the cells to the right and below the 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."
Any thoughts???
