View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Arun Arun is offline
external usenet poster
 
Posts: 103
Default List Function - Adding new lines w/ formulas

Yes, it is.

"Ken Johnson" wrote:


Arun wrote:
I have created a database list (<Data <List <Create List) with 10
different columns. A couple of the columns have formulas in them that refer
to cells in the same row - for example summing up the row total.

When I add a new line, how do I get these formulas to copy into the new row?


Is Tools|Options|Edit|"Extend data range formats and formulas" checked?

Ken Johnson