Cannot Insert "ADDITIONAL" Rows in MS Excel 2013 (Home and Student Version 2013)

Question

Greetings,

I'm just simply want to insert "extra rows" in between rows with contents. Unfortunately, this notice always shows up:

Would anyone be kind enough to provide a solution for this? Thank you.
By the way, there's no formula implemented whatsoever on the sheet.

Answer 1

Hi Nathaniel,

Please let us know your updates at your convenience if you need further help.

Thanks,

Cliff

Answer 2

Hi Nathaniel,

To clarify the issue, I’d like you to confirm and provide the following.

a. List the detailed reproducing steps of the issue you are experiencing.

b. Open a new file and input the same content to see if you encounter the same issue.

Generally, the issue may occur if a formula has been added to the entire worksheet or if formatting (such as a border) has been added to an entire column or row. Please check if you have formatting added. If yes, you may delete the formatting to see the outcome.

Thanks,

Cliff

Answer 3

It usually means you have data in the last row or column. The other likely cause is having "objects" on the sheet like buttons, dropdown lists, images and so on in the last row or column.