Excel doesn't show a selected cell when window lost focus

Anonymous
2014-04-20T22:48:34+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments No comments
{count} votes

26 answers

Sort by: Most helpful
  1. Anonymous
    2017-02-09T14:55:40+00:00

    YESSS! Finally I found a workaround (Office 2007).

    Highlight your cells and hit Ctrl+C!!

    It will surround them with a vague dotted border persistent to lose-focus.

    69 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2017-02-10T07:27:49+00:00

    Neat trick. 

    Bit of a nuisance if you have just copied something to the clipboard though!

    13 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2017-03-03T12:45:01+00:00

    Insane how this is still a thing...

    18 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2017-10-25T13:27:11+00:00

    Ditto, Ditto, Ditto.

    Why are relatively simple usability problems so difficult for Microsoft to address?

    16 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2017-11-02T18:38:09+00:00

    Brilliant !

    3 people found this answer helpful.
    0 comments No comments