Apr 30 2021 04:51 PM - last edited on Nov 09 2023 11:09 AM by
Hello guys!
I hope someone helps me.
My excel is not incrementing a sequence when I use the fill handle function.
For example, if I type, 1, 2, 3..., in the cells A1, A2, A3...respectively and select the range A1:A3, and I pull down, it fills the next cells with 1, 2, 3, 1, 2, 3, 1, 2, 3... instead of 4, 5, 6, 7,...
I don't know what is happening, it always worked well.
I checked in "Options->Advanced-> "Enable fill handle and Drag and drop" it is marked as "Enable".
Curiously, when I click on "Edit Custom Lists" button, it doesn't open the window for edit list. this button is not working, it looks a kind of bug in the application.
Could anyone help me?
Thanks a lot.
Apr 30 2021 08:48 PM
May 01 2021 07:23 AM
May 01 2021 07:39 AM
May 01 2021 07:41 AM
May 03 2021 12:10 PM
Hi Patrick2788,
When I type 1 and hold "Ctrl" + Fill handle, it repeat 1, 1, 1, 1, 1, 1, 1...
Sep 16 2021 10:07 AM
I have been having the same issue. I confirm in the advanced tab that the enable fill check box is selected and I also confirmed calculations are set to automatic instead of manual. Have there been any solutions to this?
Apr 16 2022 02:31 PM
Hello, @AGibbs
Do you resolve the issue? I'm facing the same, without being able to find a solution.
Apr 20 2022 02:14 AM - edited Apr 20 2022 02:27 AM
No fix. To be honest, I gave up.
As I use two laptop, when I need make lists using that resource, I use other computer, also, depending of kind of list, I use formulas, copy and paste special as text.
It is stupid, I know, but at least I continue working.
If anyone found a solution, please share it.
Apr 20 2022 02:28 AM
Hello @Jluisnun
Thanks for the Feedback.
The problem came up [ at least for me] once I changed the region on the windows. After that, the fill handle stop function and the custom list cannot be edited [ window don't popup ]. Most probably is a bug in the office suite. Also, re-install office [normal/clean] didn't resolve the issue.
I have escalated the matter with Microsoft support, and I will update you on any development.
Jun 14 2022 01:33 AM
I was experiencing this as a periodic problem, which (for me) a solution has been found, via another group. If the sheet you are working on has a filter applied, then it stops the auto increment. As soon as I clear any filters it increments perfectly.
I hope this resolves the issue for some of you
Oct 20 2022 04:19 AM
Oct 20 2022 06:13 AM
Hello @mariomeyrelles_esw,
I resolved it long back, and I don't remember exactly the steps in detail. The solution - at least for me - was a clean uninstall/install of the office suite. Regretfully, the "clean" uninstall does not erase everything, resulting in intervention in the registry [ before the installation of the suite]. You can consult many threads regarding the registry related to a clean uninstall of the office.
Hope to help
Nov 01 2022 05:33 PM
Nov 01 2022 06:01 PM
May 02 2023 02:40 AM
I had the same problem and none of the responses worked; and, like you, it was working great and then suddenly stopped incrementing. But then I noticed when I inadvertently clicked on a cell I was copying (using CTRL D to copy the above cell) that I had accidentally put in a blank line using ALT>ENTER (enters a return to a new line in a cell). I deleted the line with a backspace and VOILA, the drop and drag with increment began working again. Since I was copying all my cells using the CTRL D function, I was copying that blank line each time and I can only assume that the drop and drag feature just did not see the number above the blank line as anything but text. Anyway...another problem solved in my world! Hope this helps in yours!
May 26 2023 03:26 AM
I experienced the same issue and have no truck with reinstalling unless something is life threatening. The solution for me was that for some reason the formatting of this column of data was set to 'General.' I set it to Number and the crowd went wild...
Jun 17 2023 05:00 AM
Jun 20 2023 04:06 PM
I am happy it worked for you!