insert row below

[cmefly]

hi,

usually when i insert a row, the row is inserted a row above the one i hi-lite.
is there anyway to have it insert a row beneath the one i hi-lite?

 

[Joe4]

Just go to the next line below it! I don't think you can reset the Excel default, if that is what you mean.

If you are working with macros, .Offset(1,0) will take you down one more line.

 

[cmefly]

but my whole point is to copy the format of the above row

 

[Joe4]

Unless you want to write a small macro to do it, just insert the row, and then use the Format copy button to copy the format of the row you want.

If you want to do this in one step instead of 2 or 3, you can write a small macro to do it.

 

[cmefly]

I'm not too good with macros but i'm in the process of learning....any chance you might be able to help me out here.....?

 

[Joe4]

If you place your cursor on the row you want to insert below, this will do that and copy the format of that row (like you asked).

Sub InsertRowBelow()

    Application.ScreenUpdating = False
    
    ActiveCell.Offset(1, 0).EntireRow.Insert
    ActiveCell.EntireRow.Copy
    ActiveCell.Offset(1, 0).Select
    Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False

    Application.ScreenUpdating = True

End Sub

 

[cmefly]

thank you very much...i greatly appreciate your help....
thank you!

 

[Sansi]

I know that this question is very old, but if someone needs answer, this is how I solve it.
My sheet was filtered and I need to insert row bellow in the middle of table. I did it by copying specific row, right click on that same row, insert paste row. This inserted the same row I copied, which I was needed, but you can clear contents if you need blank row.