Automatically add one row

[MSSailor]

I have a list that where I add info that are then summed up in each column.
Problem I have is that I have to add new rows after filled rows to Row 19
To add a row function. No probs to do that manually. But I want to do it
automatically. It does not matter.
Is it possible?

Row 1 One Two Three
Row 2 Four Five Six
Row 3 Seven Eight Nine
Row 4
Row 5
Row nn
Row19
Row 20 Add Column A Add column B Add column C

 

[Roger Govier]

Hi

If you are using XL2003, place your cursor in cell A1>Data>List>uncheck My
List has headers
Data>List>Total

Repeat the formula you see in C20, in B20 and A20.

As you add more rows, the total row will move down automatically.

 

[MSSailor]

Sorry did not mention that I have XL2000.
Thanks for telling

 

[Shane Devenshire]

Hi,

Unfortunately the List feature did not get introduced until 2003. In
earlier versions you might:

Set up a total further down which sums everything =SUM(A1:A50) for example,
even though you don't have data yet for many of the rows. Then you can
"move" the total row up by applying a Data, Filter, AutoFilter command to the
range A1:A51, and choosing NonBlanks from the auto filter dropdown.

Alternatively you could write code.