This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello there,
My problem is very simple, but bothering at same time. I'm working with two big monitors, and sometimes have multiple Excel windows open at same time. The problem is, when I select a cell in one window and the go to another one, the selection from a first window is lost... What I mean, the cell is still selected, but I can't see it any more. Let me illustrate with an example:
I'm crazy? Not really. Sometimes working with big tables, I'd like to select a cell/row/area/whatever and keep it as reference. The old version of office didn't have this problem. It's more, notepad does it good!
Any idea? Help please!!!
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.
Microsoft needs to add this choice to the Options.
Until then i found:
https://www.extendoffice.com/documents/excel/1494-excel-highlight-active-row-and-column.html#a1
There is a nice VBA script that auto-highlights rows and columns