Excel double click to AutoFit is not working with new worksheet and no wrap text or merged cell.

Anonymous
2018-12-04T00:55:01+00:00

My Excel when I create a new sheet just to prove its not working or when working with a saved file, when I double click the column or roles to auto fit nothing happens. 

Wrap Text is not enable and merged cells are not used either. 

I created a new sheet with no merged cells and no wrapped text on. 

I then wrote something shorter than the width of the cell so I can check to see if it works and nothing happens. 

Can anyone help me?

Many thanks,

Danny

Microsoft 365 Insider | Excel | MacOS

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
Answer accepted by question author
Anonymous
2018-12-20T21:52:10+00:00

I just wanted to let everyone know that I fixed the problem! The problem was caused by my mouse speed that was set to the highest double-click speed, under preferences/mouse. I decreased the speed to half and now its working double clicking to auto fit in excel again.  

Thank you

Was this answer helpful?

40+ people found this answer helpful.
0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-01-27T02:39:06+00:00

    Worked for me. Genius :)

    glad it worked for you! this was very annoying for me and I thought it was Excel's problem. I found the solution by mistake. lol

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-12-04T10:09:59+00:00

    Hi Danny,

    We are more than willing to help you figure it out.

    Based on my test, we can use AutoFit feature.

    To clear the situation, I need to confirm if you have tried the following steps to check the result:

    1. Select all the column.
    2. Put the mouse on the border of the column.
    3. The following icon will occur:

    1. Then you can double click to use AutoFit.

    If the issue still exists, could you please provide the following information?

    1. The OS version and Office version. (Click Excel>select About Excel)
    2. Check if all files meet the issue.
    3. Can you use it before? Which operation have you taken before the issue occurred, such as updating Office?

    Regards,

    Qing

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    2019-01-27T00:41:04+00:00

    Worked for me. Genius :)

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2018-12-04T17:02:55+00:00

    Hi, thank you for the feedback. 

    All files have the same problem and even If I open a new one. It won't work and I did the procedure you gave me, but still no success.

    Here is my excel version and IOS. 

    I have just created a new excel file and wrote ddd and double clicked it on top to see if would auto fit, but no. I am also experienced using excel and this feature is something I use a lot, but for some reason it is not working. 

    Many thanks 

    Hi Danny,

    We are more than willing to help you figure it out.

    Based on my test, we can use AutoFit feature.

    To clear the situation, I need to confirm if you have tried the following steps to check the result:

    1. Select all the column.
    2. Put the mouse on the border of the column.
    3. The following icon will occur:

    1. Then you can double click to use AutoFit.

    If the issue still exists, could you please provide the following information?

    1. The OS version and Office version. (Click Excel>select About Excel)
    2. Check if all files meet the issue.
    3. Can you use it before? Which operation have you taken before the issue occurred, such as updating Office?

    Regards,

    Qing

    Was this answer helpful?

    0 comments