Forum Discussion

conwayamyc's avatar
conwayamyc
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's avatar
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
  • go8mgqg's avatar
    go8mgqg
    Copper Contributor
    May 03, 2021
    don't worry i gave you a like because it did really help
    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      May 04, 2021
      lol...It was just a joke with the like, you need to give me or anyone here something.
      I and most of the others here, give without embarrassing anything.
      The best thing to do is to pass on what you have learned without embarrassing anything .
      .. this will keep happiness in the chain 🙂

      Enjay your Office

      Nikolino
  • conwayamyc's avatar
    conwayamyc
    Copper Contributor
    Jul 10, 2020

    NikolinoDE I can autofill, that is working. It is when I am done dragging, the menu is different. How do I change the quick menu button to this referenced picture? 

    • TheAntony's avatar
      TheAntony
      Iron Contributor
      Jul 11, 2020

      conwayamyc , I'm not sure how to enable that option, but you can get a similar set of options when you drag the mouse while holding the right mouse button instead of the left mouse button.

  • conwayamyc's avatar
    conwayamyc
    Copper Contributor
    Jul 10, 2020

    NikolinoDE That is already enabled. 

Resources