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

Question

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...

Answer 1

This version solved the problem.

Answer 2

Hi,

I'm Sneha and I'd be happy to help you out with your question. Sorry for the inconvenience caused.

It seems that the issue you are experiencing may be related to Excel's settings. To change the settings so that the selected columns or rows are highlighted, follow these steps:

1. Open Excel and click on the "File" tab in the top-left corner.
2. Click on "Options" at the bottom of the left-hand menu.
3. In the Excel Options window, click on "Advanced" in the left-hand menu.
4. In the Editing options section, make sure that the "Extend data range formats and formulas" checkbox is selected.
5. In the Display options for this worksheet section, make sure that the "Show selection" checkbox is selected.
6. Click "OK" to save the changes.

If these settings were already selected, you may also want to check that the "Enable fill handle and cell drag-and-drop" option is selected in the Advanced options, as this can sometimes affect the selection highlighting.

If these steps do not resolve the issue, you may want to try resetting Excel to its default settings again, as this can sometimes help with persistent issues.

If you have any other questions or need assistance with anything, please don't hesitate to let me know. I'm here to help to the best of my ability.

Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Best Regards, Sneha

Answer 3

Thank you for your answer.

I checked:

4. "Extend data range formats and formulas" checkbox is selected
5. There is no "Show selection" checkbox in the Display options for this worksheet section :(

Checked that the "Enable fill handle and cell drag-and-drop" option is selected in the Advanced options.

Restored excel to default settings again. Restarted computer.

No results...

More ideas?

Thank you

Answer 4

Hello, I am Leonielhou, an Independent Advisor and a user like you, I am happy to help clarify any questions you may have.

Go to File > Options > Advanced > Display secrion > Check " Disable hardware acceleration "

Answer 5

Hello, Leon,

thank you for answer.

No such "Disable hardware acceleration" in Display section... :( . More ideas?