Forum Discussion
Tableau Formule automatique nouvelle ligne
Perceval Did you create a structured table? Click anywhere inside your table. Do you than get a new ribbon at the top called "Table Design" (don't know what this is called in French Excel).
If not, you are not working with a structured Excel table. On the Home ribbon you'll find an icon like this:
Alternatively, select any cell inside the data range and press Ctrl-T. Confirm whether the range has headers or not. In a structured table, all cells with a formula will replicate when you insert or add a new row at the bottom.
Riny_van_Eekelen Hi ! Thanks for help ; it is indeed a structured table, that's why I can't understand why my formulas are not replicated. I ended up building a new table on another sheet and it works perfectly. I can't understand why, but nothing worked, but it did the trick flawlessly by creating a new table. Lost some hours on it, nevermind, now it works.
Thanks !