formulas down without manual copy

I¹m trying to have my formulas flow down the page for each column.
Without manually copying them down the page I thought I could use the
³list² feature. Thus hopefully only having the list move down the page
as data is added. Sounds ok?

But when I actually insert a list over the data and formulas- it looks
great Except that when you goto add a new line of data the formulas
aren¹t there? Going into list wizard and changing the settings for each
column seems very longwinded and seemingly not possible to even add the
formulas correctly for each column. Ah..

I would have thought that by changing into List that the formulas for
each cell would simply follow down . .

Is there another way or should i be now using a database program instead?

Thanks.

I personally set row 1 as my template row with all appropriate formats and
formulas, and then give it a RangeName and reduce it to 1 unit
high..........then I record a macro and assign it to a "RowFormat" button in
my header above my frozen line so it's always on screen and it does the job
for me and even increments the item numbers in column A............when my
database is more than one screen wide, I even put an extra button on the
right side of the header area.

Vaya con Dios,
Chuck, CABGx3

"james" <[email protected]> wrote in message
news:[email protected]...
> I¹m trying to have my formulas flow down the page for each column.
> Without manually copying them down the page I thought I could use the
> ³list² feature. Thus hopefully only having the list move down the page
> as data is added. Sounds ok?
>
> But when I actually insert a list over the data and formulas- it looks
> great Except that when you goto add a new line of data the formulas
> aren¹t there? Going into list wizard and changing the settings for each
> column seems very longwinded and seemingly not possible to even add the
> formulas correctly for each column. Ah..
>
> I would have thought that by changing into List that the formulas for
> each cell would simply follow down . .
>
> Is there another way or should i be now using a database program instead?
>
> Thanks.