Forum Discussion
Newbie question about auto-fill
Hi,
I am new to excel online (365) and I am trying to turn off the autofill.
ONE TIME I filled in a blank with a unique keystroke in a data sheet of 700 lines. Now, every time I try to fill in new information, the unique, 1-time-information-filled pops in instead. How do I remove this on the online (365) excel. It's really becoming bothersome! Thank you.
5 Replies
After working on Excel Spreadsheets for years with no problem, this same "AutoFill/AutoComplete" started happening just recently. I copy pasted info to 40 individual cells in the same column and it changed several hundred cells in that column. I fixed it, at least for now, by going to the Excel File/Options/Advanced tab in Excel and checked (turned on) the "Enable AutoComplete for cell values", then turned it off. This seems to have worked....at least for now. rswc90
- This is what MS says about it :
Microsoft Office Excel completes text entries that you start to type in a column of data — if the first few letters that you type match an existing entry in that column. If you want to stop automatic completion, you can turn this option off.
Click File > Options.
Click Advanced, and then under Editing options, select or clear the Enable AutoComplete for cell values check box to turn this option on or off.BeingManishThanks for this -- I already saw this -- It must pertain to desktop versions -- not online versions. When I go to "Options, this is my ONLY choice (see attached photos).
Excel for Web practically have no settings, at least so far. Nothing except Regional.
