View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrselkoil mrselkoil is offline
external usenet poster
 
Posts: 1
Default inserting a blank row

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.