Formulas Not Copying Down in Table after Starting a New Row

Ruth2002

New member
Joined
Aug 29, 2019
Messages
9
Reaction score
0
Points
0
Excel Version(s)
Excel 365
I have a table that has like 15 rows. When I first started the table, I was only using 3 formulas in the row. Now on row 15, I have added 2 more formulas, so there are 5 cells in the row with formulas. However, when I hit tab to start a new row, it only brings down the original 3 formulas, not the new 2 formulas.

I have gone into Options and turned on "Fill formulas in tables to create calculated columns", but it still doesn't work.

This is happening on multiple spreadsheets and I am clueless what to do.

Thanks in advance.
 
As are we without seeing the workbook in question! Can you please attach a sample book that shows the issue. Are you sure that all of the columns are included in the table?
 
Sample File

It should all be the same table.

The line highlighted is where I put in the new formulas. As you can see it brings down some formulas but not all.
 

Attachments

  • sample table file.xlsx
    24.9 KB · Views: 18
If I understand you well, this works for me.
When I enter data below the row (yellow color), a new row of formulas is automatically inserted.
 

Attachments

  • Ruth2002-navic-10288.xlsx
    18.2 KB · Views: 10
Back
Top