Excel used to fill in words in a column after the word was entered once. Now it seems to decide on its own when to do this. Options>Advanced>Autofill On and Off did nothing except autofill the word if the new typing was done in the cell directly below. That is, if a word was entered in cell A1, it would auto fill that word if it was begun in cell A2, but not if it was entered into any other cell in column A.
Can someone tell me why this feature has become so haphazard? And, can it be changed? Everything I have tried does nothing to make it consistent.
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
* Knowing the Excel version and operating system would also be an advantage.
Office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.