+ Reply to Thread
Results 1 to 2 of 2

A Crosshair to Highlight the Entire Row/Column Prior to active cel

Hybrid View

  1. #1
    Josh Lakien
    Guest

    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. #2
    Dave Peterson
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1