Excel automatically highlighting row and column

  • Thread starter Thread starter gmax137
  • Start date Start date
  • Tags Tags
    Excel Windows
AI Thread Summary
Excel users on Windows 11 report an automatic green highlighting feature that activates when opening files, which some find annoying. This feature, known as "Focus Cell," can be toggled on or off via the View tab or by using the shortcut Alt + W + E + F. Discussions reveal that this built-in functionality may not be available in older versions of Excel, such as the 2019 Home version on Windows 10. Users express frustration over locating buttons and features, particularly when they are unfamiliar with their names. Overall, the conversation highlights the differences in Excel features across versions and the challenges users face in navigating them.
gmax137
Science Advisor
Education Advisor
Messages
3,138
Reaction score
3,624
Excel on Windows 11. My windows was "updated" yesterday. Now, when I open an excel file, I get this green highlighting. Anyone know how to turn this off? It really annoys me.
Thanks!

Example 1 (Cursor is in cell D9)
excel1.jpg


Example 2 (cursor in F12)
excel2.jpg
 
Computer science news on Phys.org
https://techcommunity.microsoft.com/blog/microsoft365insiderblog/increase-ease-of-navigation-with-focus-cell-in-excel/4264531 said:
On the View tab, select Focus Cell button to toggle the feature on and off, or press Alt + W + E + F.
 
  • Like
  • Informative
Likes harborsparrow, jedishrfu and berkeman
Just so, @jack action Thanks so much. I searched on "excel highlight row and column" but all the hits I got were VBA recipes to make excel do the highlighting. Apparently enough people wanted to do this, that MS built it in at some point ("Focus Cell")
My biggest problem with excel is finding the right buttons, especially when I don't know the name of the button, lol.
 
@jack action -- Is that only on newer versions of Excel and Win11? I'm using an old 2019 Home version on Win10.
 
@berkeman Here's where I see it (Microsoft 365 on Win 11). Not sure if that will help you. Although as I mentioned above, there are lots of hits describing how to do the highlighting via VBA, so the built in feature must not have been available.

excel3.jpg
 
Well, the date has now passed, and Windows 10 is no longer supported. Hopefully, the readers of this forum have done one of the many ways this issue can be handled. If not, do a YouTube search and a smorgasbord of solutions will be returned. What I want to mention is that I chose to use a debloated Windows from a debloater. There are many available options, e.g., Chris Titus Utilities (I used a product called Velotic, which also features AI to prevent your computer from overheating etc...
I've been having problems for the past few weeks with the display on my Dell computer. I bought the computer new back in 2019 or so, which makes it about 6 years old. My monitor is a 27" HP monitor that I bought for another computer (an HP Pavilion), recently demised, back in about 2012 or 2013. As far as I can tell, the computer, which is running a 10-core Xeon Scalable processor, is functioning as it should. The first symptom was that the screen would go dark, which I would attempt to...
Back
Top