Share via

Excel Double-Click Autofill/Copy Cells Not Working

Anonymous
2018-11-02T15:32:44+00:00

So, i'm not sure if IT updated my Excel or not (running 2016), but as of today when I double-click in a cell to fill in the cells below it (in lieu of dragging down hundreds of cells) it automatically fills the series and pops up the Quick Analysis button vs. the button that allowed me to select Copy Cells or Fill Series.  This is very annoying since I do this a lot.  Is there a way to revert back to this function?  I know I can right-click the cell and drag it, but that's not practical for me.

I haven't messed with any checkboxes that would have turned anything on or off.

Thanks in advance.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-11-02T16:28:04+00:00

    This not your fault. But there has been many changes in this functionality and these changes have broken the old way of working. So, this is caused by Office updates. Unfortunately, you will have to rely on right click and drag way only which you have been doing.

    May I request a small help from you? These forum posts are not read by Microsoft engineers. This feedback should go to Microsoft engineers for them to consider this.

    You should report this to Microsoft so that Microsoft developers should look into this. There are 2 ways to give this feedback -

    1. Open Excel > File > Feedback > I have a suggestion
    2. Through Uservoice - Click the following link to see the feedback of others and to provide feedback - https://excel.uservoice.com/

    Thank you Vijay!  I did find I could add/use the Flash Fill button in my Quick Access Toolbar to mimic the copy function of the double-click, and then if I just double click it does the Fill Series...so I can still get it done, I just have to do it two different ways.  I'll also comment to the developers...thanks for that suggestion.

    4 people found this answer helpful.
    0 comments
  2. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2018-11-02T15:48:02+00:00

    This not your fault. But there has been many changes in this functionality and these changes have broken the old way of working. So, this is caused by Office updates. Unfortunately, you will have to rely on right click and drag way only which you have been doing.

    May I request a small help from you? These forum posts are not read by Microsoft engineers. This feedback should go to Microsoft engineers for them to consider this.

    You should report this to Microsoft so that Microsoft developers should look into this. There are 2 ways to give this feedback -

    1. Open Excel > File > Feedback > I have a suggestion
    2. Through Uservoice - Click the following link to see the feedback of others and to provide feedback - https://excel.uservoice.com/

    3 people found this answer helpful.
    0 comments