Excel 2007 : Need to disable table formula fill-down / autofill...

Nope, that didn't work. Example attached:

The goal is for users to complete something (far more involved than the example) with yellow fields allowed for data entry, non-yellow would be calculations (protection will be in place, etc).

If you enter a 350 in cell C5, all is well - it only affects cell C5. If, however, a user decides that the quantity is "oh, 175 from here, 57 from there, and 118 from over there..." and enter a formula like "+175+57+118" because they can't do the math in their head, then it autofills that formula down through the entire table in that column.

The goal is that those cells would not be used until needed and discretely completed by the user for the next part, with it's own desired quantity that is not dependent on any other lines (hope that makes sense).

If a user enters the above formula, I only want the result in that cell, not auto-filled...

That does indeed work, thanks. It does yield some interesting consequences however - in that example file, put your cursor on cell B13 and insert a row; does it insert a row *and* add a value/formula in cell D13 for you?

It's doing that for me on this example and on my actual file now. And the formula it's putting in there adds to a relevant value from the table, but isn't simply copying a formula from somewhere, it's making it up from scratch somehow... ?

Part of what I'm going for with the table is a template kind of financial analysis for folks to use to evaluate a new project, and from use to use it will change as to the part numbers used, etc. One time it may need 5 numbers, the next time 500. I'm trying to build something that the user can insert rows into as necessary that will retain and fill-down formulas as appropriate (ext price), etc. Your fix does that, and turns off the auto-fill of items I *dont'* want that to do (great), but inserting rows is now doing this funky thing, hehe. Ever seen that before? Is it doing it for you?

Glad to see it's not just me losing my mind.

The original $2.00 in D5 was simply me entering a '2' in that cell.

In my other worksheet inserting a row makes a formula "=15*5" appear, for a visible value of 75. There's no value or formula in that column that is '75', though there is a value of 75 a few columns over.

Weeeeeeeeeird.

Thanks again for your help, by the way.

Anyone noticing this formula copy "feature" - it even exists in 2010 and 2016...

The way to fix it is to make sure that every row is a copy of the top row, prior to inserting your data.