Excel Consistently Insert Blank Row at Top of Sheet (after frozen first row)

I am trying to create an Excel sheet that'll have a blank row at the top for my coworkers to request things. Unlike this post "Consistantly insert rows from top of page in Excel" my excel sheet has a frozen first row as labels for the columns. Either way, the code didn't work for me anyways, so I would like clarification on the previous post as well.

1 Answer

This can be solved with a little modification to the explanation you are referring to. First I froze the first row. Then I recorded a macro that inserts a row above the second row. This is the code.

Sub NewRow() Rows("2:2").Select Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
End Sub

Then I added a button by clicking on the developers tab and insert. Then I connected the macro to the button. For a detailed explanation: .

You should also be careful that your button doesn't resize when inserting new rows, this can be prevented by right-clicking the button and choose edit. Then you have to go the properties tab and select "don't move or size cells".

Now you have a fully functional button that inserts rows below your frozen pane.