Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default A Crosshair to Highlight the Entire Row/Column Prior to active cel

Occassionally, a worksheet needs to be viewed in a very low zoom. I had to do
this when I had many columns of data and needed to see most of them all at
once. I could not freeze the pains because I would lose coverage of the
required columns. When I zoomed out, it was very had to track back on the
same row that the data was on. For example, I needed to look at data M221and
I221 and then look at data on A221. I found it difficult to stay on the same
line when moving back to column A (at-a-glance), because the data was so
small.

If there was a crosshair feature that one could enable, this would eliminate
inaccuracy. The prior cells in the column would be faintly highlighted and
the prior cells in the row would be faintly hghlighted, making it simple to
track back along the same line.

I am currently using the newest version of Microsoft Excel.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default A Crosshair to Highlight the Entire Row/Column Prior to active cel

Maybe you could use Chip Pearson's rowliner addin:
http://www.cpearson.com/excel/RowLiner.htm

Or maybe you could use:
window|new window
window|arrange (horizontal??)

And view both areas of your worksheet in different windows.

Josh Lakien wrote:

Occassionally, a worksheet needs to be viewed in a very low zoom. I had to do
this when I had many columns of data and needed to see most of them all at
once. I could not freeze the pains because I would lose coverage of the
required columns. When I zoomed out, it was very had to track back on the
same row that the data was on. For example, I needed to look at data M221and
I221 and then look at data on A221. I found it difficult to stay on the same
line when moving back to column A (at-a-glance), because the data was so
small.

If there was a crosshair feature that one could enable, this would eliminate
inaccuracy. The prior cells in the column would be faintly highlighted and
the prior cells in the row would be faintly hghlighted, making it simple to
track back along the same line.

I am currently using the newest version of Microsoft Excel.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get row and column of active cell to highlight? chappi Excel Discussion (Misc queries) 2 August 19th 09 10:21 PM
How do I highlight the active row and column headers? GaryW Setting up and Configuration of Excel 2 August 29th 07 03:26 PM
How to highlight active row and column? JMB Excel Programming 0 June 14th 05 06:37 AM
How to highlight active row and column? JMB Excel Programming 0 June 14th 05 06:25 AM
How to highlight active row and column? Ricktaxx Excel Programming 4 April 20th 05 05:37 PM


All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"