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:



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!