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.
 

AliGW

Administrator
Joined
Nov 8, 2015
Messages
1,785
Reaction score
1
Points
38
Location
Ipswich, Suffolk, England
Excel Version(s)
MS 365 (Beta Insider Channel)
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?
 

Ruth2002

New member
Joined
Aug 29, 2019
Messages
9
Reaction score
0
Points
0
Excel Version(s)
Excel 365
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

navic

New member
Joined
Aug 27, 2013
Messages
901
Reaction score
0
Points
0
Excel Version(s)
Excel 2013
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
Top