Forum Discussion
My table does not auto-insert all the formulas when a new row is inserted
Hi, My excel sheet has 5 columns with formulas. I converted it into a "Table" so that those formulas auto-fill whenever I insert a new row (between rows). Upon inserting a new row, only 4 out o...
You have somehow broken the table autofill.
Delete all formulas in the column except one. Go to that cell with the formula and press F2 and ENTER.
this works; thanks a lot;
This works.
You are amazing. I have been searching for an answer for more than year. And today I came across this post. It was EXACTLY what happened. Thank you!
- Worked perfectly for me. My original problem was that I had a pre-existing spreadsheet w/ formulas that I turned into a table. I found that any column w/ existing formulas wouldn't auto-fill but any new column I created and entered a new formula, it would work. the F2+Enter workaround saved me a ton of legwork getting all my existing formula columns to behave as desired. Other threads on the same topic had mediators answering that Excel tables don't do that, period. Glad I tried one more search and found this solution. Thanks much!!!
- Hi Detlef Lewin,
I've tried doing the above but it still does not work..
Also tried redoing the entire excel sheet from scratch and realised the table autofill gets broken when i try to "lock" those cells and "protect" the excel sheet.
Not sure why..Take a look at some of the suggested solutions:
https://www.google.com/search?q=protect+ecel+sheet+with+a+table
