Auto filling data in rows

[David Morrison]

I'm looking for advice on how to do something that would be useful for
me. I know* it is possible, but don't know how to set it up.

I'm using Excel 2004 for Mac on Leopard.

The spreadsheet has four columns where data is entered. It then has
another 7 which are all formulas using values from the first four
columns and from the row above. (This is actually for calculating costs
and fuel consumption for my car.)

As new entries are required, I enter the data in the four columns for
the first empty row at the bottom. In order to get the formulae into
this row, I select the columns with formulae from the previous row and
fill down into the new row.

This is fine, and I have been doing it this way for years. What I would
like is some way to have the contents of certain columns of the previous
row automatically copied to the new row.

*I said above that I know that this can be done. I know it can because
one of the columns is doing it. As soon as I enter values in the cells
it uses in its formula, the formula appears in that column's cell. There
is nothing in the cell before then.

I've tried the help in Excel, but have found nothing. I suspect this is
because I do not know what words to use to describe it.

Any help gratefully received.

David

 

[Bob Greenblatt]

I'm looking for advice on how to do something that would be useful for
me. I know* it is possible, but don't know how to set it up.

I'm using Excel 2004 for Mac on Leopard.

The spreadsheet has four columns where data is entered. It then has
another 7 which are all formulas using values from the first four
columns and from the row above. (This is actually for calculating costs
and fuel consumption for my car.)

As new entries are required, I enter the data in the four columns for
the first empty row at the bottom. In order to get the formulae into
this row, I select the columns with formulae from the previous row and
fill down into the new row.

This is fine, and I have been doing it this way for years. What I would
like is some way to have the contents of certain columns of the previous
row automatically copied to the new row.

*I said above that I know that this can be done. I know it can because
one of the columns is doing it. As soon as I enter values in the cells
it uses in its formula, the formula appears in that column's cell. There
is nothing in the cell before then.

I've tried the help in Excel, but have found nothing. I suspect this is
because I do not know what words to use to describe it.

Any help gratefully received.

David

Try looking in help for List manager. I think you'll find that your "list"
does not include all columns. You should also check in preferences-Edit for
extending formulas in lists.