continuing formulas down tables automatically, not working for me

[jitterbug888]

Hello,
this issue again, the spreadsheet attached here.

I thought if I convert these ranges to tables, then the formulas should automatically continue down the columns as new data is entered in column E and G?
How to automate the columns F, H, I ,J to auto fill down the table?
Column G needs to be manually entered as prices may vary per sale.

kind regards,

[Bo_Ry]

Convert table back to range, > select only data field E1:J14 > Convert to able again
Key-in G15 and see.

[jitterbug888]

no luck
is it just my excel maybe if its working for you?

[jitterbug888]

I see the calculator you attached works when I downloaded it...!
did you do anything after converting back to table again prior to typing into G15?
I had noticed the drop down menus were there but the down arrow was missing in your sheet,

[Bo_Ry]

I delete all rows below G14 to clear out everything below.
Table auto fill every formula include Data Validation
I use Excel 365.
Table.gif

[jitterbug888]

thanks for that,
i`m trying to get rid of the table, but it wont allow me to convert to range, my spreadsheet is dysfunctional I think. nothing is locked.

[AliGW]

You can't convert PART of a table to a range. Select the whole table.

[jitterbug888]

I select all the table columns, but its still greyed out...
if I select the whole sheet or other columns besides these, I get no ability to choose the table design tab,

[AliGW]

There are columns in your table not selected (A to D and K just from the visual). That's why it's greyed out.

[jitterbug888]

there has to be something wrong with this attached spreadsheet..
because I can create a table, and then partially relase the table to a range or the whole table to range in another sample spreadsheet attached here,
and the original attached here that has the problem.
wondering if I have to release the drop down menu`s or formulas.

[Pepe Le Mokko]

I thought if I convert these ranges to tables, then the formulas should automatically continue down the columns as new data is entered in column E and G?
How to automate the columns F, H, I ,J to auto fill down the table?

kind regards,

Have you checked the auto-correct options on your sheet ?
File tab - Options- proofing - Auto correct options - auto format as you type - see if the two last check boxes are checked

[jitterbug888]

I have the following settings

Attachment 629041

[JeteMc]

I am not able to replicate your issue. I downloaded the sales affiliate payments calculator_columns not working.xlsx‎ file, enabled editing, selected cell J21 and pressed the tab key. E22:J22 then became the next row in the table and the formulas in F22, H22:J22 all copied down. The data validation also worked in cell E22.

[jitterbug888]

thanks for confirming JeteMc, I opened it this morning and the cells do fill down now as you say.
i`ll close this as solved.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.