I have a spreadsheet that automatically fills in calculating cells when others on the row are filled in. Not sure how and when this happened but some calculating cells don't get filled in automatically.



Why is that?

I think it might have to do with the fact that the last cells are calculated on cells that are automatically filled in. Can Excel not automatically fill in cells after the previous cells have automatically filled in?

What do you mean by " automatically filled in"?
Using a macro? Formula ?
Perhaps post a sheet

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Adding a value into col B populates J
Adding a value into col F populates cols H and I

K and l are never populated even if M is given a value

Attached Files

electric10-OLD.xlsx (32.0 KB, 13 views)

Try the following : select B1: M18 - Insert tab - Click on table.
Check " my table has headers"in the " Create table" window. ( some headers will be added where there are none - change them if needed)
Click OK
Now when values are added the calculated values automatically extend

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post