Info Excel auto fill

Occasional Visitor

Hi I have my laptop with system windows 10 pro the auto fill on excel 2013 doesn't work even though is enabled in the settings, thank you

2 Replies


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




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.