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 No comments
{count} votes
Answer accepted by question author
  1. Anonymous
    2023-04-26T15:37:52+00:00

    This version solved the problem.

    0 comments No comments

19 additional answers

Sort by: Most helpful
  1. Anonymous
    2023-04-11T05:44:30+00:00

    Wow!! Nice find! Very true. Anything that's greater than 88% zoom will have this problem. Anything less than equal to 88% zoom and its fine for highlighting rows! For highlighting columns the problem remained all they way down to 50%, which is not useable.

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2023-04-11T06:02:29+00:00

    Thank you! Rows started highlight at 60%, columns at 10% zoom... ( impossible to work :( )

    At 87% columns highlights only the first column:

    0 comments No comments
  3. Anonymous
    2023-04-25T06:18:05+00:00

    HI everyone, we have the same problem. When we launch the fisrt time Excel, there is no problem. But when we accept or not the new UI interface, we relaunch Excel and The problem appears.

    Reduce the zoom to 30% works for us.

    We are in VDI environnement (Citrix ,Windows 10, VMware)

    Regards

    0 comments No comments
  4. Anonymous
    2023-04-27T06:23:43+00:00

    Yes, you are right, the problem is fixed in new version!!! I'm so happy :)

    0 comments No comments