In order for a cell to know what to display, it must be told. If you don't
want to copy your formula down, about the only simple option is to click in
your existing records and go to DataForm to enter new ones. The Form feature
will carry your calculations down to the new records as it appends them to
the bottom of the existing list.

HTH |:)

"Seige Silver" wrote:

I have a worksheet with three columns. Col1 is item, Col2 is price and Col3
is quantity. I need a column 4 that calculates col2 * col3 and displays
total. I tried formulas, but i need the total to be displayed automatically
whenever i navigate to that column after entering col 2 and col 3. I dont
want to drag the formula manually to se the results. It should be like pure
forms. Any advice?