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

jorpe · 24 Jun 2010

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 · 24 Jun 2010

There is some very useful info here:

Insert Rows using a Macro

It looks pretty complicated though

Thorsen · 24 Jun 2010

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 · 24 Jun 2010

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.

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

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