Forum Discussion
Stop the Auto-Fill in Excel - Existing solutions not working
I am trying to enter a formula into a cell (not a table), and Excel keeps auto-filling down the column to a random number of cells. I do not want anything to pre-fill down the column. when I try to delete the pre-filled data, it doesn't go away, unless I delete all the pre-filled data + my original cell that needs the formula.
From what I've understood from similar posts and solutions, I have deselected the necessary options so that this shouldn't happen, but I've clearly missed something here.
Here are the screenshots of my existing excel options:
2 Replies
"when I try to delete the pre-filled data, it doesn't go away, unless I delete all the pre-filled data + my original cell that needs the formula."
Based on that description alone, I'm guessing the formula you've used has returned multiple results in a "spilled" array. When selected, does a faint blue border automatically appear around the entire range of results? Is the formula greyed out in the formula bar for every cell in the range, with the exception of the first cell? If so, then this is what's referred to as a "dynamic array" formula. The results are spilled automatically in the worksheet, and the formula can only be edited in the first cell.
To assist you further, please share the formula you're attempting and/or a screenshot of the results. Thank you.
- Can you post a screen-shot of the sheet and perhaps a before and after picture?
