Insert a Row Below

[mjones]

Hi All,

Is there a way to insert a row below the row you’re on?

I know, you’ll say to go to the row below that one and insert, which inserts a row above and below the row I want. HOWEVER, I can’t go to the row below because it’s likely filtered out.

Currently, I’m unfiltering, finding the row again (why won’t Excel stay on the row I’m on after unfiltering – I digress), go to the row below, add the row above, and filter again . . . very cumbersome when doing it hundreds of times in a 7200-row spreadsheet.

Thanks again,

Michele

 

[PeteWright]

Hello @mjones

I'm not sure if it's hidden somewhere in the Excel Options, but if you don't mind installing a 3rd party tool like the Excel AddOn ASAP Utilities for Excel it's possible.
ASAP Utilities is free for Home use but requires registration if used in a Company.

 

[mjones]

Thank you Pete. I have a business account with Microsoft but I'll check it out. Much appreciated.

 

[Michael M]

If you do it on a regular basis, you could use a macro

Sub InsertRow()
dim r as long
r = activerow
Cells(r + 1, 1).EntireRow.Insert
End Sub

 

[Burrgogi]

. . . very cumbersome when doing it hundreds of times in a 7200-row spreadsheet.

For ease of use & convenience sake, take the code that @Michael M gave you above and assign it to a button or shape. That way, you can just click on it to run your macro.

 

[Burrgogi]

There was something about @Michael M that did not look right to me. I tested it out and it did not work for me. "activerow" is not a valid object that exists - not for Excel 2010 anyway. Perhaps it is for Office 365 but I can't say for sure since I don't use that particular version.

Here is the corrected code.

Sub InsertRow()
dim r as long
r = ActiveCell.Row
Cells(r + 1, 1).EntireRow.Insert
End Sub

 

[Michael M]

@Burrgogi
Thx for the pickup...typing while in the car is not healthy or wise, (not in the drivers seat BTW)....

 

[Burrgogi]

No worries Michael, its'a tag team effort sometimes. And it looks like I made a typo of my own when I commented earlier.

There was something about @Michael M that did not look right to me.

Although I haven't seen a picture of Michael, I'm sure @Michael M looks fine. It was his code I was referring to. Oops!

 

[Michael M]

 

[mjones]

Thank you all! Exactly what I needed! You've saved me tons of time!