make excel automatically insert a new row when you hit enter?

[jorpe]

I'm working with a basic spreadsheet template I got online for expenses, but I dont know how to make it automatically insert another row when I hit enter so I never run out of rows

 

[clunkfish]

There is some very useful info here:

Insert Rows using a Macro

It looks pretty complicated though

 

[Thorsen]

I have not found a way to do this,

but I usually right-click on the row where I want to add rows and hit the "i" key, this way I can right-click and then "i" without moving the mouse i do this 5-10 times real quick

instead of rightclicking moving mouse to insert then moving mouse back to row then repeating.

Not a true fix, but it makes it easier.

 

[jorpe]

Thank you, It looks like there's not really an easy solution... I appreciate the help though, I just group add around 20 at a time, which works for what I need just not as pretty as it would be.