Autofilling Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1621812%22%20slang%3D%22en-US%22%3EAutofilling%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1621812%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20question%20regarding%20cells%20in%20a%20table.%20When%20I%20add%20a%20new%20row%20to%20a%20table%2C%20it%20autofills%20a%20few%20cells%20with%20data%20from%20the%20first%20row%20in%20the%20table.%20I%20used%20to%20have%20formulas%20set%20up%20to%20autofill%2C%20but%20have%20since%20removed%20them%20as%20I%20enter%20them%20manually%20now.%20How%20do%20I%20get%20these%20cells%20to%20stop%20automatically%20entering%20the%20information%20from%20the%20first%20cells%3F%20I%20am%20using%20a%20Mac.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1621812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1622130%22%20slang%3D%22en-US%22%3ERe%3A%20Autofilling%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622130%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F776275%22%20target%3D%22_blank%22%3E%40bcdooley795%3C%2FA%3E%26nbsp%3BNot%20sure%20if%20this%20helps%2C%20but%20press%20Excel%20(top%20left)%2C%20Preferences...%2C%20Tables%26amp%3BFilters.%3C%2FP%3E%3CP%3ECheck%20these%20settings%20and%20uncheck%20%22Automatically%20fill%20formulas%22.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-08-31%20at%2007.35.10.png%22%20style%3D%22width%3A%20257px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215504i9D2103443FBA2159%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%202020-08-31%20at%2007.35.10.png%22%20alt%3D%22Screenshot%202020-08-31%20at%2007.35.10.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1623144%22%20slang%3D%22en-US%22%3ERe%3A%20Autofilling%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623144%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you%20for%20the%20reply%20-%20I%20have%20tried%20that%2C%20and%20for%20some%20reason%2C%20it%20does%20not%20solve%20the%20issue.%20Any%20other%20ideas%3F%20Thanks%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1623455%22%20slang%3D%22en-US%22%3ERe%3A%20Autofilling%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1623455%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F776275%22%20target%3D%22_blank%22%3E%40bcdooley795%3C%2FA%3E%26nbsp%3BSorry%2C%20don't%20know.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

3 Replies

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

Check these settings and uncheck "Automatically fill formulas".

Screenshot 2020-08-31 at 07.35.10.png

 

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

@bcdooley795 Sorry, don't know.