Solved

Side-by-side with other types of windows

Posted on 2015-01-05
2
55 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 69

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
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 how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

822 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