I have a 165 row 10 column worksheet. I have been able to insert blank rows
before by right mouse clicking and choosing insert. Now when I try that I
get this message: "To prevent possible loss of data, Excel can't shift
nonblank cells off the worksheet. Try to locate the last non blank cell by
pressing CNTRL+End (I have no end key on my keyboard) and delete or clear all
cells between the last cell and the end of your data. Then select A1 and
save your workbook to reset the last cell used." I don't understand what
this message means and I need to insert blank rows on that sheet. Please,
anyone, help. Using Office Edition 2003.

The message means you have something...a space maybe.......in a cell in row
65536.

Excel won't shift that row down because it has no more rows to shift to.

Select all rows below your actual data and EditDeleteEntire row.

Do same for columns to right of data.

Now: IMPORTANT......Save the workbook which resets the used range.


Gord Dibben MS Excel MVP

On Wed, 24 Jan 2007 13:07:01 -0800, mrselkoil
wrote:

I have a 165 row 10 column worksheet. I have been able to insert blank rows
before by right mouse clicking and choosing insert. Now when I try that I
get this message: "To prevent possible loss of data, Excel can't shift
nonblank cells off the worksheet. Try to locate the last non blank cell by
pressing CNTRL+End (I have no end key on my keyboard) and delete or clear all
cells between the last cell and the end of your data. Then select A1 and
save your workbook to reset the last cell used." I don't understand what
this message means and I need to insert blank rows on that sheet. Please,
anyone, help. Using Office Edition 2003.