Forum Discussion
Info Excel auto fill
What is your plan or what you want to accomplish, I cannot see exactly from the translation.
It would be an advantage if you could explain the problem in more detail to make sure that the translation translates it correctly.
Inserting a file (without sensitive data) with a description of the problem on the basis of the file would be an advantage.
Enable or disable autofill
Click the File tab and click Options.
Switch to the “Advanced” category, activate or deactivate the “Activate fill box and cell drag & drop” option in the “Editing options” section and click “OK” to confirm.
Turn automatic completion of cell entries 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.
Maybe you help these two Options settings on.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Well, after setting up my account so I could respond in the community, I have lost the conversation I wanted to comment on.
I have a spreadsheet and have gone to options, advanced and made sure the auto fill box is checked. The issue I am having is that some cells auto fill when I start to type and some do not. I work at a non profit and we assist a lot of people with unemployment. When filling in the reason someone calls the center, sometime when I start to type "un" it will auto fill, sometimes it will not. I cannot figure out how to fix the cells in the column to auto fill.
The spread sheet has first name, last name, phone number and reason for calling. Is there a way for it to auto fill the phone number by name if the same person calls more than once.
Thanks
