Solved

Side-by-side with other types of windows

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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

747 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

9 Experts available now in Live!

Get 1:1 Help Now