Forum Discussion

HansGermany's avatar
HansGermany
Copper Contributor
Mar 04, 2019
Solved

Fill data automatically in worksheet cells does not work anymore

Dear all,

thank you for reading. I have a problem with my excel program and was not found a solution with google: Filling data automatically in worksheet cells does not work anymore.

 

I reboot my system (win 7, 64-bit), then start excel (MS Office Prof. Plus 2013) with an empty worksheet (no filters, etc.). Then I am typing 1,2,3,4 into cells A1 to A4 and select those 4 cells. Normaly, when I move my mouse pointer down to the right edge of selected cells, the pointer changes to a 'plus' sign. But this does not happen anymore and therefore it is not possible to click the edge and expand the selected cells and filling data automatically (1,2,3,4,5,6,7,8,9,...)

 

On the other hand, I can not move the selected cells, by draging the edge of the selected cells to an other position.

 

Does anyone have similar problems? How can I repair this?

 

Regards,

Hans.

 

  • Hi Hans,

     

    Please go to the Excel Options and make sure that the below option is enabled.

     

     

    Hope that help

     

    Regards,

    Haytham

3 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi Hans,

     

    Please go to the Excel Options and make sure that the below option is enabled.

     

     

    Hope that help

     

    Regards,

    Haytham

    • HansGermany's avatar
      HansGermany
      Copper Contributor

      Hello Haytham,

       

      that was the solution. Thank you very much for that hint.

       

      Anyway, I don't unterstand how this option could be changed. Maybe a shortcut key combo?

       

      Thank you 

      Hans.

      • Haytham Amairah's avatar
        Haytham Amairah
        Silver Contributor

        Hi Hans,

         

        I don't think that there is a keyboard shortcut to change this option.

        It might be changed because of a bug, accidental error, macro code, or third-party add-in.

         

        Best Regards

Resources