Yesterday when I was editing an Excel 2007 file, I tried to add a new line, but it failed every time. Excel said “Cannot shif objects off sheet”, as shown in the figure below.

The simplest solution is to press
Ctrl+6, you can’t add new lines again. The specific reasons can be found in the following links:

http://office.microsoft.com/en-us/excel/HA102412411033.aspx

Reproduced in: https://blog.51cto.com/jackiechen/281830