Solved

Side-by-side with other types of windows

Posted on 2015-01-05
2
54 Views
Last Modified: 2015-01-05
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.
0
Comment
Question by:frugalmule
2 Comments
 
LVL 47

Assisted Solution

by:Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs) earned 250 total points
ID: 40532400
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
 
LVL 68

Accepted Solution

by:
Qlemo earned 250 total points
ID: 40532444
You can automate that suggested visualization with a OnSelectionChange event handler, but that sounds a bit drastic.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now