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