Forum Discussion

eXile821's avatar
eXile821
Copper Contributor
Mar 04, 2026
Solved

Need help autofilling.

Good morning all,     Thought I posted this but I am not seeing it anywhere so I apologize if this is a repeat.   I was tasked with filling in a spreadsheet with data including; Our part number,...
community
excel
Formulas and Functions
Macros and VBA
  • eXile821's avatar
    eXile821
    Mar 06, 2026

    That is perfect,

     

    Thank you for your help!

RobertGJudge's avatar
RobertGJudge
Copper Contributor
Mar 19, 2026

     I use Microsoft® Excel® for Microsoft 365 MSO (Version 2603 Build 16.0.19822.20012) 64-bit.  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 done for me in the past.

     Many of the entries I am making are to enter “Boston” into a column I have named “Address City.”  Normally, when I have done this in EXCEL, after I enter “Boston” as the “Address City” for George Washington and 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 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.