How to insert "n" rows into an Excel spreadsheet?

I simply want to insert "n" rows. None of the resources that I have found have stated how to do this. The closest I have seen is "select same number of rows". That is fraught with problems. Any hints / VBA code or other ideas?


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:

enter image description here

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.

enter image description here

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

enter image description here

Right-click and choose Insert

enter image description here

Boom! 5 empty rows!

enter image description here

It can't get any simpler than that!


I just select 5 or 7 or 12 whatever rows on the lhs and then right-click and insert - job done...