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