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,124
Reaction score
3,583
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
 
In my discussions elsewhere, I've noticed a lot of disagreement regarding AI. A question that comes up is, "Is AI hype?" Unfortunately, when this question is asked, the one asking, as far as I can tell, may mean one of three things which can lead to lots of confusion. I'll list them out now for clarity. 1. Can AI do everything a human can do and how close are we to that? 2. Are corporations and governments using the promise of AI to gain more power for themselves? 3. Are AI and transhumans...
Sorry if 'Profile Badge' is not the correct term. I have an MS 365 subscription and I've noticed on my Word documents the small circle with my initials in it is sometimes different in colour document to document (it's the circle at the top right of the doc, that, when you hover over it it tells you you're signed in; if you click on it you get a bit more info). Last night I had four docs with a red circle, one with blue. When I closed the blue and opened it again it was red. Today I have 3...
Back
Top