Share via

Excel: selected columns or rows do not highlights. Throw selected cells highlights. How to change?

Anonymous
2023-02-21T13:12:07+00:00

I create new book in excel (no protected or locked cells). And select columns or rows. Then the selection do not highlight in grey (only outline line):

Throw, if I select cells - selection highlights:

I tried:

  1. Restore excel defaults, by deleting from regedit and restarting.
  2. Deleted files from roaming (C:\Users\User_Name\AppData\Roaming\Microsoft\Excel)
  3. Checked Add-ins.
  4. Repaired Microsoft Office.
  5. Uninstalled Office 365, restarted and installed again.
  6. Created new user and installed office 365.
  7. ?what else?

Nothing helps to change this option... Windows 10 Pro

Please, help...

Microsoft 365 and Office | Excel | Other | 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
Answer accepted by question author
  1. Anonymous
    2023-04-26T15:37:52+00:00

    This version solved the problem.

    0 comments

19 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-25T09:13:07+00:00

    Office Version - Microsoft® Excel® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20214) 64-bit

    OS - Win10 Pro

    I have the same issue as reported, and it is crazy stupid annoying! :(

    But I have noticed one additional thing to report. I created a new Win10 user account, logged in and opened excel. I did not have this issue! Close exce, and start again. Still no issue! Yay! So perhaps the issue is related to my user account?!?!

    Then I decided, from within excel, to signin to my office 365 account. After logging in and restarting excel ... boom! Problem has retuned. Note I have not made any changes to the default excel config. Simply created new Win10 user, and started excel, keeping all default settings.

    So my question, what is happening within my signing in to office365 that is causing this issue?

    I've gone through enabling / disabling all the various options within excel, and am not able to solve what is causing this issue?

    0 comments
  2. Anonymous
    2023-03-28T01:59:26+00:00

    Addendum ... also tried this with the 32bit version of office and same issue.

    Of note is that my colleagues who have the same version of excel / office 365, they are not experiencing this problem.

    Therefore this suggests that there is some config within my office365 config that is causing this issue, as it only occurs once i signin to office365.

    I hope this helps a support person figure out what is happening, or where to look.

    0 comments
  3. Anonymous
    2023-04-03T05:57:21+00:00

    The same happened to me - after creating new user - excel worked good. And when I signed to my office 365 account - problem is on :(

    0 comments
  4. Anonymous
    2023-04-10T21:51:21+00:00

    Running into the same issue with a client of mine. Do all of the cells highlight if you drop the zoom on the Excel sheet below 100%?

    1 person found this answer helpful.
    0 comments