When in TABLE mode, how to auto-copy formula when creating new entry ?

[brazool]

Hello

I have all my data in tables (ctrl+t), but excel will only copy SOME formulas when I go to new entry at the bottom.
1. How to correct that?
2. And how can I un-table a table?

Kind regards

[Cheeky Charlie]

It only copies formulae which are consistent down the table - maybe check your formulae follow a rule.

Right-click and "convert to range"

[brazool]

can you be more specific about that formula rule ?

[Cheeky Charlie]

If:
C1 = A1 + B1
and
C2 = A2 + B2
then Excel can be fairly confident that
C3 = A3 + B3
and will fill it in appropriately

But if (as above, but)
C2 = A2 - B2
then Excel gets sad, angry and confused and will not play with you

So check your formulae are consistent throughout your table.

HTH