Jan 30 2021 10:33 AM
I created a table. When I add or insert new rows the formulas do not autofill into the new row. I must copy and past the formula into the new row cell. I understand this is not the normal behavior for tables. How do I fix it.
Feb 14 2021 06:56 PM
Feb 15 2021 07:06 AM
Thanks for your response. In the meantime, I realized that the formula that would not auto-fill was first created before the column was included in the table. Apparently, when a formula is created outside the table and later becomes part of a table, Excel will not deal with it properly. I eventually re-did the formula for that column from within the table, and now it does auto-fill as expected.
Feb 15 2021 08:21 PM
Mar 07 2023 11:15 AM