How do I prevent Excel from automatically highlighting cells?

Question

This question has been asked previously, but closed with no resolution. So posting a new question and hoping we get a resolution this time.

How do we prevent Excel from automatically highlighting a cell? It does this based on the highlight color of the cell above, and will even jump over up to 2 rows to match the highlighting above.

I want to clarify this question is only about turning off highlighting. It has nothing to do with disabling other features such as flash fill or formula copying. Strictly, how do we turn off the automatic highlight "feature"?

Thanks.

Answer 1

Could you share us a screenshot of which feature you want to disable, Conditional formatting?

A macro may do such actions.

Answer 2

This example has been created using Excel 365, but the "feature" has been in Excel for years. I do not want auto-highlighting. But I don't want to impact the way Excel handles formulas to disable the highlighting.

Answer 3

The feature is designed in Excel and there is no such option to disable it.

You may send feedback to Microsoft to add a such option to disable it.

Excel · Community (microsoft.com)

Send feedback to Microsoft with the Feedback Hub app - Microsoft Support

Answer 4

Thank you. But surely there must be some way to turn this off (registry hack, something). Unfortunately, Microsoft has demonstrated they don't listen to customer feedback regarding these unwanted "features", nor on providing easy ways to disable the unwanted features. So posting yet another feedback response seems to be a waste of time. The feedback hub is full of people complaining about various uncontrollable features, and has been for years. Sadly, Microsoft developers continue to ignore us.

Answer 5

Microsoft takes customer feedback seriously and continuously works to improve its products and services based on feedback.