0

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?

1

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!

  • Thx - it's actually green in MacOs but in any case it does work. Never noticed that box before. Any other thoughts/hints on what you've uncovered in excel? – javadba Sep 29 at 16:36
0

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .