Insert Rows

  • Thread starter Thread starter sree
  • Start date Start date
S

sree

Hi,
I have a simple excel sheet which is saved in eencrypted format. I am unable
to insert rows in the same. Whenever I try, it says, 'To prevent possible
loss of data, Excel cannot shift non-blank cells off the document...'. Could
find what the real problem is.
 
Check by using CTRL + End and see where Excel takes you.

Could be Excel thinks you have data in the bottom row of the worlsheet so it
won't shify cells down for inserting a row.

If CTRL + End takes you to bottom of sheet, delete unused rows then save the
workbook.


Gord Dibben MS Excel MVP
 
Back
Top