auto insert row

[The Grim Discovery]

[TABLE="width: 700"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Player
[/TD]
[TD]Game 1[/TD]
[TD]Game 2[/TD]
[TD]Game 3[/TD]
[TD]Game 4
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD]Total
[/TD]
[TD]Total
[/TD]
[TD]Total
[/TD]
[TD]Total
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Morning people

Is there anyway I can get Excel to automatically enter a new row once I've populated A2:E2? The behaviour I'm looking for is for the current row 3 to move down one every time the row above it is populated.
Lots of thanks in advance

 

[Special-K99]

If you place the Totals at the top you wont have this trouble.
Creating a table and adding a Total Row may solve this.

 

[The Grim Discovery]

It's not that it's trouble - more it's a solution that would be desirable in dealing with a couple of design and user-related issues...if it's possible