+ Reply to Thread
Results 1 to 2 of 2

In Excel, using ctrl-f after a previous find doesn't highlight the text of the last search

  1. #1
    Registered User
    Join Date
    09-27-2017
    Location
    Maryland, USA
    MS-Off Ver
    2016
    Posts
    1

    Angry In Excel, using ctrl-f after a previous find doesn't highlight the text of the last search

    I have an Excel sheet that I search repeatedly over the course of the day. Here is the use case:
    1. Open Excel and the document
    2. Press ctrl-f and type search criteria
    3. Press enter. Excel finds the cell with the text. (Find window stays open by default)
    4. Press ctrl-f to search again. The Find and Replace window gets the focus.
    5. Here is the issue: When I start typing, it appends the text to the existing text to search. (Instead of selecting the previous search so the first key press clears the last search)
    Note: It does highlight it if you close the search box after every search, but not if you don't.

    This is a new computer at a new company; at my old company, the search criteria was highlighted after doing a search in both Excel 2013 and Excel 2016. I am using Excel 2016.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: In Excel, using ctrl-f after a previous find doesn't highlight the text of the last se

    I use Excel 2010 and it behaves the same way. So does 2003. I don't recall Excel ever behaving as you describe in the last paragraph.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2003 ctrl F feature doesn't work
    By Talk_4 in forum Excel General
    Replies: 5
    Last Post: 02-20-2015, 02:33 PM
  2. Replies: 2
    Last Post: 01-02-2015, 07:53 AM
  3. [SOLVED] Find text and highlight in Excel cell
    By mqcai4613 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-16-2013, 08:41 AM
  4. [SOLVED] search for text, then search for previous text, replace 1st text including number from 2nd
    By kldailey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2012, 05:23 PM
  5. Ctrl Find Doesn't Find Words in Xls
    By nothingisthis in forum Excel General
    Replies: 3
    Last Post: 06-14-2011, 04:09 AM
  6. Replies: 1
    Last Post: 08-03-2005, 09:05 AM
  7. [SOLVED] Highlight cells with ctrl-click but only un-highlight one cell
    By hagan in forum Excel General
    Replies: 5
    Last Post: 05-27-2005, 02:05 PM

Tags for this Thread

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