auto formula fill

I hardly knew what to put in the subject line! Anyway, I have a sheet with
rows of data, with some cells containing formulas based on data I manually
type in other cells. As I type in the data, some cells with formulas will
automatically complete, but others won't and I have to manually drag down the
formula from the preceding row. Why is this? I would like all cells with a
formula in them to automatically complete as I type in data. Connie

Well, I guess I had the wrong subject line and that threw everyone off.
Can't believe no one in this whole wide world could answer my question. I
had to do a lot of digging, and found the answer here:
http://support.microsoft.com/?id=231...22120121120120

"Connie Martin" wrote:

> I hardly knew what to put in the subject line! Anyway, I have a sheet with
> rows of data, with some cells containing formulas based on data I manually
> type in other cells. As I type in the data, some cells with formulas will
> automatically complete, but others won't and I have to manually drag down the
> formula from the preceding row. Why is this? I would like all cells with a
> formula in them to automatically complete as I type in data. Connie