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