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.
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!