Forum Discussion

Copper Contributor

Apr 30, 2021

Fill handle not increment a sequence

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 a...

excel

JMB17

Bronze Contributor

May 01, 2021

You're not, by chance, holding down the control key?

Jluisnun

Copper Contributor

May 01, 2021

Hi JMB17,

No, I am doing exactly as before. I have used Excel for my years and I have never seen an error like that.

Thanks.

Patrick2788
Silver Contributor
May 01, 2021
What happens if you enter 1 in a cell then use ctr+fill handle down?
- Jluisnun
  Copper Contributor
  May 03, 2021
  Hi Patrick2788,
  
  When I type 1 and hold "Ctrl" + Fill handle, it repeat 1, 1, 1, 1, 1, 1, 1...
  - AGibbs
    Copper Contributor
    Sep 16, 2021
    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?
    Jluisnun