Forum Discussion

Pat-J's avatar
Pat-J
Copper Contributor
Jun 21, 2020
Solved

L'insertion d'une ligne dans une table ne duplique pas les formules

Bonjour, Pour mieux gérer les données de mon tableur, j'ai transformé le contenu en table. J'avais compris que lorsque l'on insère une ligne dans un tableau, les formules et les MEFC étaient recond...
  • Zack Barresse's avatar
    Jun 24, 2020
    Hello there,

    This is most likely an issue with the Table not recognizing the formula as a Calculated Column. This is something Excel senses when entering formulas, although there is an internal audit to determine the data type for a column. Before I tell you how to force this, there is the possibility of a setting being off, which you should check.

    File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type:
    Two settings reside here, ensure they're both checked. They are:
    • Include new rows and columns in table
    • Fill formulas in tables to create calculated columns

    The latter of the above two items is the one you need checked for this specific issue. However, the former item should also be checked when working with Tables.

    To ensure a Table column is recognized as a Calculated Column:
    Copy the formula in desired column. Any row.
    Select the entire column. Do not include headers or total row.
    Clear contents. The keyboard 'Delete' key will do this, or right-click > clear contents.
    Paste the formula into a single cell in desired column, confirm with ENTER.

    The above should work for you. Ensure you are not filtering the Table or have any hidden rows when you do this.