auto formula fill

[Guest]

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

 

[Guest]

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=231002#XSLTH3140121122120121120120