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?
How to insert ānā rows into an Excel spreadsheet
ms office
Related Question
- Microsoft Word notebook layout – insert equation
- Want VBA code to make Excel Mac 2011 play sound file based on name in a cell
- AppleScript to Save Excel Chart as PNG Broken after Recent Update
- How to insert a Word (or cvs) document or Video file to a Word document with AppleScript
- Is there something like macros in Outlook 2016 on Mac
Best Answer
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!