EXCEL auto fill is not working

Question

 I am entering a large amount of personal addresses into EXCEL.  The EXCEL autofill (I think that is the correct term) is not working for me as it has worked in the past.

 Many of the entries I am making are to enter “Boston” into a column I have named “Address City.”  In the past, when I have done this in EXCEL, for example, after I enter “Boston” as the “Address City” for George Washington and for Thomas Jefferson, if I try to enter “Boston” as the Address City for Franklin Roosevelt, I just type “B” and EXCEL with automatically fill the cell with “Boston.”  Unfortunately, EXCEL is not doing that for me now.  I have to type out the whole word “Boston” into each cell where I want “Boston” to appear.  I will be entering hundreds of rows.  I would like to get EXCEL to use “autofill” as it has worked for me in the past.

 I have checked the two boxes in EXCEL Options/Advanced: 1. Enable fill handle and cell drag-and drop AND 2. Alert before overwriting cells.  I would appreciate suggestions to help me get this good EXCEL function working for me again.  Thank you for your attention.

Answer 1

Hi Robert Judge,

What you’re describing is usually AutoComplete for cell values, not the fill handle setting. This also matches what the AI answer pointed out. AutoComplete controls what happens while typing in a column, not drag‑and‑fill behavior.

• Please check this setting first: File > Options > Advanced > Editing options > Enable AutoComplete for cell values

If it is already checked, try this refresh step:

• Uncheck it and click OK
• Go back and check it again, then click OK
• Close Excel and reopen it

That can sometimes help if the feature is enabled but not responding correctly.

Also, Excel AutoComplete only works from a continuous block of data in the same column. If there is a blank row between earlier entries like Boston and the cell you are editing, AutoComplete may stop working. It also may not work if the earlier text is not an exact match, for example if one entry has an extra space such as **Boston **.

For faster entry with hundreds of rows, you can also use these alternatives:

• Alt + Down Arrow: shows a list of previous entries in that column
• Fill handle drag: if several adjacent rows should contain Boston
• Ctrl + Enter: select multiple cells, type Boston, then press Ctrl + Enter to fill all selected cells at once

A good test is to try this in a new blank workbook with no blank rows in the list. If it works there, the issue is likely related to the layout or contents of the original sheet.

Please let me know if this proves useful to you, or if you would like further assistance.

I'm looking forward to your reply.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The behavior described is controlled by Excel’s AutoComplete feature, not the fill handle/drag-and-drop settings. AutoComplete likely needs to be turned back on.

Turn AutoComplete back on in Excel for Windows:

1. Select File > Options.
2. In the left pane, select Advanced.
3. Under Editing options, make sure Enable AutoComplete for cell values is checked.
4. Select OK.

After this, when typing in a column:

• If a new entry starts with the same characters as an existing text entry in that column (for example, typing B where “Boston” already exists above), Excel will automatically complete the rest of the word.
• This works only for text or text+number combinations, not for entries that are only numbers, dates, or times.

If AutoComplete is on but still not working as expected, confirm that:

• The entries being repeated are in the same column.
• The entries are text (e.g., “Boston”), not just numbers or dates.

For filling repeated values or patterns across many rows, the fill handle can also be used:

1. Type “Boston” once in the first cell of the Address City column.
2. Select that cell.
3. Drag the fill handle (small square at the bottom-right corner of the cell) down over the rows that should also contain “Boston”.

---

References:

• Turn automatic completion of cell entries on or off
• Fill data automatically in worksheet cells
• Enter a series of numbers, dates, or other items