Forum Discussion

palbertarrio's avatar
palbertarrio
Copper Contributor
Jan 04, 2020

Autorellenar fechas consecutivas

No me esta funcionando en excel 365 el autorellenar fechas o números consecutivos ni tampoco me aparece el botón de opciones de autorrelleno. Que debería hacer para que me funcione
excel
Abiola1's avatar
Abiola1
MVP
Jan 04, 2020
Hello,

Need English translation.

Regards
palbertarrio's avatar
palbertarrio
Copper Contributor
Jan 04, 2020

The autofill dates or consecutive numbers is not working for me in excel 365, nor does the auto-fill options button appear to me. What should I do to make it work for me?Abiola1 

  • Abiola1's avatar
    Abiola1
    MVP
    Jan 04, 2020
    Hello,

    Normally, the auto fill should work. For example, you have 01/01/2020 in cell A1. When you drag down the value using the auto-fill rectangle icon located bottom-right of the active cell which, in this case, is cell A1, it should work perfectly. You can fill bases on Month,Year etc.

    You can also use the Fill located in the Editing group of the Homs tab.

    Kindly let me know if this works...
    • palbertarrio's avatar
      palbertarrio
      Copper Contributor
      Jan 04, 2020

      Hello, that operation is clear to me. What happens is that in certain books, I do not have the series fill options enabled. and I don't see the fill options button in the lower right corner when the autofill flag appears. In a new book that does not happen, everything goes perfectly. but in an existing book made with another excel this problem appears to me. In addition, instead of the filling options button, the analysis button appears. Sls pablo

      • Branka Bradule's avatar
        Branka Bradule
        Brass Contributor
        Jan 05, 2020

        palbertarrio are you able to see the Fill option in the "problematic" Excel workbook in the Home tab?

        Please see below what you should be able to see:

         

         

        Thanks for feedback.

         

        Cheers,

        Branka

Resources