Automatic Row insertion

**collinsc** · 05-30-2009, 11:42 AM

Hi

I have a worsksheet which i keep adding rows to. I have the 'total' of values in the rows in say row 20. So when i reach row 19 i am 'inserting new row' to take the 'total' row down one, and then do this again, and again everytime i add a value.

Is there a way to set it to automatically go down one row?

thanks

**mewingkitty** · 05-30-2009, 03:22 PM

eh,
You're looking for a faster way to insert a row? Isn't it like... right click then i. How much were you hoping to shorten that?

**mewingkitty** · 05-30-2009, 03:35 PM

Eh well, made this for you.
Just in case 2 clicks is too many, you can now insert a new row with 0 clicks. If you enter information in the cell above "Total" in column three (and there is info in all the cells above it), and hit enter or change cells or anything, it'll insert a new row, bumping the row with "total" in it down.

Let me know if you can tweak that for your own needs or if you need a hand customizing it further.

mew!

**JBeaucaire** · 05-30-2009, 07:27 PM

I think what you're looking for is Excel's LIST function.

Highlight all the data EXCEPT the totals and press CTRL-L to ativate the LIST. Now Excel will offer you an expansion row with a * on it anytime you put your cursor into the data set. If you enter any data anywhere on that * row, it will extend the data set down, pushing everything down and updating your total formula outside the LIST.