28 Comments

1. 

   Jan Lagrand on December 24, 2013 at 11:27 am

   Hi Mike,

   I noticed that in the Windows Excel example that you’re using, the results of the Formulas (=Ax+Bx) are incorrect! All results are 100 less than the correct result and in the last row the difference is even 1600!
   Not a major issue for what you are explaining, but I just noticed.

   Best regards,
   Jan

2. 

   Jan Lagrand on December 24, 2013 at 11:33 am

   Oops, my mistake. The outcomes in the Windows example are OK. There is a difference in the formulas used between the two examples. In the Mac version it is =Ax+Bx, but in the Windows example it is =A1+A2 that gets copied.

   Best regards,
   Jan

3. 

   Mike Thomas on December 25, 2013 at 1:12 pm

   Well spotted Jan. I didn’t script or plan this video – it was a quickie in response to a question somebody had asked, hence me not checking the data thoroughly. As you say it doesn’t matter in terms of the issue that I was explaining.

   -Mike-

4. 

   Mick on August 6, 2015 at 5:41 pm

   My fill handle was turned off in Excel 2013…Was drivign me mad thanks a million

5. 

   Nathiya on September 25, 2015 at 7:37 am

   Thank you so much sir this video was very useful for me at right time

6. 

   Homood on January 4, 2016 at 12:55 am

   I see the black cross but still doesn’t work!! any other suggestions?

7. 

   Mike Thomas on January 15, 2016 at 11:08 pm

   Homood, do you have a blank column to the left of the column that you are trying to autofill? Autofill only works if there is data in the column to the left.

8. 

   Asif Khan on February 10, 2016 at 10:19 am

   Thank you Mike for the Video, Fill handle was driving me nuts

9. 

   gnaneswary on March 27, 2016 at 2:40 pm

   thank you so much ! =D

10. 

    Nev on May 12, 2016 at 12:06 pm

    That’s solved my problem then. I had a blank column to the left. Thanks.

11. 

    Suzan on July 17, 2016 at 10:43 am

    Fantastic, now I know what was my problem.The blank left column. Many many thanks.

12. 

    Abdul on September 11, 2016 at 2:25 am

    This saved my life. Thanks for the tip!

13. 

    tom on January 24, 2017 at 11:14 am

    Hi Mike,

    I have just installed MS Office 2013.
    In excel everything is set up as it should be. All columns are populated.
    Fill handle works as drag and drop, but it doesn’t work as double click. Black cross is showing though.
    Any ideas?
    Thank you

    Tom

14. 

    Mike Thomas on January 24, 2017 at 8:38 pm

    You need to have data down the column immediately to the left of the cell you are trying to double click on so Excel knows how far down to copy. Other than that, I have no idea

15. 

    Chetan on April 11, 2017 at 7:57 pm

    Thanks for the video

16. 

    Renu on May 29, 2017 at 11:26 am

    when i double click on the +sign,only the first cell is copied to all the cells in the column.How to fix that?

17. 

    Cesar on July 7, 2017 at 12:01 am

    Thanks

18. 

    Gan on February 12, 2018 at 11:25 pm

    Mike Thomas: Thank you for the tip. That’s exactly what happened with me. I had a blank column to the left of the columns. After I deleted the blank column, I can auto fill again.

19. 

    Jen R on October 11, 2018 at 7:52 pm

    when i double click on the +sign, the contents of the first cell are copied to all the cells in the column. I confirmed that the fill handle and drag and drop box is checked and it is. How do I fix this? It worked before.

20. 

    Mike Thomas on October 11, 2018 at 8:33 pm

    Hi Jen – most likely you calculation has been set to Manual. Click the Formulas tab on the Ribbon and select Calculation Options and choose AUTOMATIC

21. 

    Katina on March 22, 2019 at 2:57 pm

    My calculation is set to Automatic and Autofill is enabled, however, I still cannot get the pointer to appear when I move my cursor to the lower right corner of a cell. I have been unable to find a solution for this. Any help would be GREATLY appreciated.

22. 

    Max Calvert on March 26, 2019 at 2:01 pm

    I’ve been trying to understand this problem for a very long time. I never thought about the blank column being the culprit. Many, many thanks.

23. 

    Amber Reid on May 3, 2019 at 10:10 am

    Hi,

    I am having trouble dragging a formula. The formula is linked to a separate excel document so perhaps this is why. When I drag the cell it just copies the value, and not the formula. I just want the formula to update to pull from the next cell down on the separate worksheet, i.e. each cell in the column to refer to a different cell in the other worksheet. Can this be done automatically? Thank you

24. 

    Moshe Rich on November 25, 2019 at 9:39 pm

    Hi, I’m having trouble still because my drag and drop is checked, also my overwriting cells, but i’m still not getting a black cross. It’s just the white one. Do you know why this is? Thanks

25. 

    Mike Thomas on December 13, 2019 at 9:18 am

    Hi Moshe. I have never experienced this problem so am unable to give you an answer based on my use of Excel. I too have searched the Internet looking for an answer but cannot find anything apart from make sure Drag and Drop is checked, which it is for you. Others have exactly the same situation as you and no-one has provided a solution 🙁

    Mike

26. 

    Vijay on January 24, 2020 at 3:42 am

    Thanks a lot. It helped me.

27. 

    Anuj Sharma on May 22, 2021 at 5:16 pm

    Thanks a lot! Worked well!!

28. 

    RS on July 30, 2021 at 10:59 am

    Thanks a bunch Mike, exactly the solution I needed!