View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Larry Sartoris Larry Sartoris is offline
external usenet poster
 
Posts: 14
Default Auto fills formula automatically

Hello support,

I ran into this feature a while ago but I haven't figured out how it works,
or what conditions mke it work.

I have 2 columns of cells that I manually enter numbers into and the third
column is a calculation of the first two. After manually filling the third
cell in with the formula a few times, it began to fill in the formula
automatically by just filling in the first 2 cells. This seems like a great
feature but it works only some of the time, and not for all of my formulas.
I couldn't figure out what I'm chaning or what option needs to be checked for
this to work.

Any help would be appreciated. Hopefully I explained my question
effectively, if not please ask for additional information.

Thanks!
larry