Inserting Rows

[Julie]

When I try to insert a row in the middle of my
spreadsheet, I receive an error that says: to prevent
possible loss of data, Microsoft Excel cannot shift
nonblank cells off the worksheet. Try to delete or clear
the cells to the right and below your 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 have added rows to other spreadsheets without receiving
this edit. Is it possible there is a "prompt" turned on
that I can turn off to allow me to add rows in the middle
of my spreadsheet??

 

[Guest]

Julie,

Somehow you've got something in the very last row of your spreadsheet (i.e. Row 65536) Click on Edit|Go To|Special|Last Cell. This will take you to the offending item and you can delete or move it.

If you leave it there then Excel cannot insert a row otherwise it would have to move the value off the sheet. This is why you get the message "To prevent possible loss of data ..."

NB: This is a somewhat dirty way of preventing users from adding rows or columns to your worksheet. Just place a single space character in Cell IV65536 and any user unaware of it can add neither rows nor columns.

unlikeKansas