AutoFill within Table Not Correct

[MikeDBMan]

A table auto-fills columns but there are columns added after the initial creation of the table that do not automatically contain a formula. How do I get other columns to add the formula? And perhaps I have changed a formula after a while and want the default formula to be different now. How do I make sure the default formula is the correct one I want? TIA!

 

[Joe4]

If you use Data Tables, then you only need to enter the formula once, and it should change them for all rows in your table.

If you do not use Data Tables, then as you add new columns, you will either need to autofill the values yourself, or create some VBA to do it.

I have changed a formula after a while and want the default formula to be different now. How do I make sure the default formula is the correct one I want?

I am not sure what you mean here. Is the formula changing part way down the column, or are you wanting to change ALL the formulas in the column?
Whatever formula is in the cell you choose to autofill will be the one that is populated.

 

[MikeDBMan]

All formulas in a column should be the same but it seems the default auto-fill is a formula I don't even use anymore. But more importantly, some cells do not auto-fill at all. If that would be solved, I would be quite happy. I can't get new columns to autofill at all sometimes.

 

[Joe4]

What you are describing to me does not sound right.
I think we may need to see your file in order to see what you are talking about.
Can you upload a de-sensitized version of your file to a file sharing site and provide a link to it here?
Then describe a particular situation/example that is not working right so that we can try to replicate the behavior.

 

[MikeDBMan]

What you are describing to me does not sound right.
I think we may need to see your file in order to see what you are talking about.
Can you upload a de-sensitized version of your file to a file sharing site and provide a link to it here?
Then describe a particular situation/example that is not working right so that we can try to replicate the behavior.

Here is link to the file:

Loading Google Sheets

When inserting a new row, columns W, AN and AO do not replicate the formulas?

 

[Alex Blakenburg]

Your link to the file needs to be made public ie available to anyone with the link. I can't get to your file.
However, if a table develops inconsistencies in formulas or formatting you need to reapply the formulas or formatting to all rows in that column at the same time.
If your formula columns are all next to each other you can do all the those columns at once.

• Select a row that has the correct formula in it. (select the specific cell or consecutive formula columns)
• Ctrl+C
• Ctrl+spacebar (this will select the whole column or columns in the table range)
• Ctrl+V

Now try and add a row and see if the formula correctly autopopulates.

 

[Joe4]

Perhaps you may be experiencing this issue that MrExcel himself just made a video about:

Excel Keeps Inserting Old Formula - How to Fix It! - Episode 2640

Microsoft Excel Tutorial: Excel Keeps Inserting Old Formula - How to Fix It! Every time that Tori adds a new row to her Excel table, four columns auto-fill formulas from years ago. Oh my gosh. Ever had a crazy frustrating problem with Excel? In this video, we tackle Tori's Excel nightmare...

www.mrexcel.com