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...
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.
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.
- yes, as is shown here. I was hoping that someone might be able to tell me how to get rid of auto-completion for the online version.
