Autofilling Cells

[bcdooley795]

Hello,

I have a question regarding cells in a table. When I add a new row to a table, it autofills a few cells with data from the first row in the table. I used to have formulas set up to autofill, but have since removed them as I enter them manually now. How do I get these cells to stop automatically entering the information from the first cells? I am using a Mac.

Thank you!

[#2]

@bcdooley795 Not sure if this helps, but press Excel (top left), Preferences..., Tables&Filters.

Check these settings and uncheck "Automatically fill formulas".

[#3]

@Riny_van_Eekelen Thank you for the reply - I have tried that, and for some reason, it does not solve the issue. Any other ideas? Thanks again.

[#4]

@bcdooley795 Sorry, don't know.