Results 1 to 6 of 6

Thread: Making "find/select easier to "see"
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2005
    Posts
    740
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Making "find/select easier to "see"

    I have a large worksheet with various color schemes and I need to use the "find" feature extensively. The problem is that when my cursor is locked on a cell, it is very difficult to see where the cell is and I am wasting a lot of time trying to decipher where it is. Are there any workarounds here?

    Thanks in advance!

  2. #2
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    22,580
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Making "find/select easier to "see"

    One aid would be to glance at the Name box to the left of the formula editing box and it will show the cell's address.

  3. #3
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    35,226
    Post Thanks / Like
    Mentioned
    92 Post(s)
    Tagged
    33 Thread(s)

    Default Re: Making "find/select easier to "see"

    One way (although I think there must be a better way), click the F5 key... when the dialog box appears, click the Special button and when the next dialog box appears, click the Cancel button. The active cell will now be visible even if multiple non-contiguous cells are currently selected.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  4. #4
    Board Regular
    Join Date
    May 2005
    Posts
    740
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Making "find/select easier to "see"

    Quote Originally Posted by mikerickson View Post
    One aid would be to glance at the Name box to the left of the formula editing box and it will show the cell's address.
    haha!

    thanks

  5. #5
    Board Regular
    Join Date
    May 2005
    Posts
    740
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Making "find/select easier to "see"

    another question on this: why is it that sometimes when I try to find a name, it does not find it? I am typing it as it is in the workbook. Is it a formatting issue?

  6. #6
    MrExcel MVP mikerickson's Avatar
    Join Date
    Jan 2007
    Location
    Davis CA
    Posts
    22,580
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    15 Thread(s)

    Default Re: Making "find/select easier to "see"

    Are you looking in Values?
    When you invoke Find, do you have a multi-cell region selected? If so, it may be searching only the selected cells.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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