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
There is some very useful info here:
Insert Rows using a Macro
It looks pretty complicated though
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.
Last edited by Thorsen; 24 Jun 2010 at 14:29. Reason: correction
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.
Quote