How to insert "n" rows into an Excel spreadsheet?
Simple, even though visually it looks like it is fraught with problems.

I've been doing this for decades, literally, and I use Excel almost every day.

Ex: insert 5 empty rows between row 4 and row 5:



Click on the numeral 5 at the far left, then entire row is selected.
A small yellow box appears at the lower-left of the selected area.



Hold-drag the small yellow box down to row 10. Release the mouse button.



Right-click and choose Insert



Boom! 5 empty rows!



It can't get any simpler than that!