Side-by-side with other types of windows

I routinely view Excel sheets side-by-side other types of windows.  When I do this, I usually have a row or cells selected. However, when I go to click on the other window I have  up, I loose the selection highlighting that occurs to help me reference what I was looking at more quickly.

Is there a solution to this?  Assistance is greatly appreciated.
frugalmuleAsked:
Who is Participating?
 
QlemoConnect With a Mentor Batchelor, Developer and EE Topic AdvisorCommented:
You can automate that suggested visualization with a OnSelectionChange event handler, but that sounds a bit drastic.
0
 
Wayne Taylor (webtubbs)Connect With a Mentor Commented:
As you've discovered, the cell highlighting is only visible when that window is active. There is no way that I know of to avoid this.

What I generally do is apply other highlighting, for example setting the Fill Colour. Then set it back to no fill when done.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.