How to make a cell's formula automatically fill into other cells in column of table?

It usually does this on it's own, but sometimes like now it doesn't, but it gives me options one of which to revert the formula to what the other cells have, but in this case I want to do the inverse and change the other cells to what I've changed in this particular cell. Thanks

hi juntjoo, try drag the formula from the first row of the column and copy down, then see if subsequent formula change will automatically update rest of rows..

thx, yeah, tried that first thing as I usually do and that usually does it, but not this time.

thx, yeah, tried that first thing as I usually do and that usually does it, but not this time.

actually, after messing with it, now instead of displaying the results of the formula, it's displaying the formula itself! Is this a separate issue or related and will be solved once solving the original issue? Hopefully...

make sure cell format is "general"?

didn't help

probably it's time to upload a sample of your file

okay, apparently, you gotta remove the = first, complete changes, then go back in and re-add the =. As far as cell becoming default formula, I tried again, but this time pasting ONLY the formula. Though I don't remember ever having to do that before. Thanks for your help.