Forum Discussion

Copper Contributor

Jul 10, 2020

Where is my Autofill Options button?

Hi! I have called support and they lead me here. After I write a formula in a cell, then I drag down to autofill the next couple of cells, when I release, I do not get the "Autofill Options". Wh...

excel

Formulas and Functions

NikolinoDE

Gold Contributor

Jul 10, 2020

Go to File, Options, Advanced, Click on Fill Box and Activate Drag and Drop of Cells, Ok ... and now you have it 🙂

enjoy Excel 🙂

Nikolino

conwayamyc

Copper Contributor

Jul 10, 2020

NikolinoDE That is already enabled.

NikolinoDE
Gold Contributor
Jul 10, 2020
Believe that can help you

https://www.ablebits.com/office-addins-blog/2014/05/30/howto-use-autofill-excel/
- conwayamyc
  Copper Contributor
  Jul 10, 2020
  NikolinoDE YOU ARE THE BEST! I figured it out!
  
  File > Options > Advanced > Under Cut, Copy and Paste, enable Show Paste Button Options when content is pasted.
  
  Thank you!!
  - jsagnas1998
    Copper Contributor
    Dec 10, 2020
    Yea, same problem.