You apparently have some values in the last row of the sheet. Take a look
and see if anything is visible. If you see nothing, there may be a cell(s)
that have a space or some non-visible entry. Delete that row and see what
happens


"BonnieSC" wrote:

> Spreadsheet which I have previously been able to Insert Rows to now gives me
> the message "MS cannot shift nonblank cells off the worksheet". I have used
> this spreadsheet for over 10 years and have never encountered this before.