Automatically add one row

  • Thread starter Thread starter MSSailor
  • Start date Start date
M

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
 
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.
 
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.
 
Back
Top