+ Reply to Thread
Results 1 to 6 of 6

How to turn of Kutools-driven Find and Replace function

  1. #1
    Registered User
    Join Date
    05-15-2017
    Location
    Franklin, TN
    MS-Off Ver
    MS Office Standard 2016
    Posts
    3

    How to turn of Kutools-driven Find and Replace function

    Hi everyone. I use the Kutools add-in extensively and love the majority of its functions. The only function I absolutely disdain is the advanced Find and Replace function. Being able to search in multiple sheets at once is nice and I like being able to do so by clicking the Binoculars icon on the Navigation pane to the left, but it also replaced my Ctrl+F from its much simpler and more agile form to always use the advanced function.

    This causes many issues for quick searches when working in multiple large sheets as it creates severe lag and often crashes my Excel entirely. Would anyone know how to revert my Ctrl+F back to the simple Excel Find and Replace? Thanks in advance for your help!

  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: How to turn of Kutools-driven Find and Replace function

    I don't use kutools, but perhaps

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    05-15-2017
    Location
    Franklin, TN
    MS-Off Ver
    MS Office Standard 2016
    Posts
    3

    Re: How to turn of Kutools-driven Find and Replace function

    Thanks for this, shg. Excuse my ignorance, but where might I post this script to provide the fix?

  4. #4
    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: How to turn of Kutools-driven Find and Replace function

    You could run it in the Immediate window at any time, and it should persist for the session.

    Alt+F11 to open the VBE, Ctrl+G to open the Immediate window if it's not already visible, paste it there, press Enter.

  5. #5
    Registered User
    Join Date
    05-15-2017
    Location
    Franklin, TN
    MS-Off Ver
    MS Office Standard 2016
    Posts
    3

    Re: How to turn of Kutools-driven Find and Replace function

    I was not able to see immediate results but I rebooted the computer for other reasons, came back to this and my regular ctrl+f was restored! Thank you again!

  6. #6
    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: How to turn of Kutools-driven Find and Replace function

    You're welcome.

+ 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. Dynamic graph driven by input-driven named ranges
    By gwebb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-24-2015, 09:22 AM
  2. Replace & Find function
    By eaflynn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2013, 08:04 PM
  3. find and replace function
    By tkeeper in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2013, 05:20 AM
  4. Function driven by 3rd party cell contents
    By TPort in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2012, 09:06 PM
  5. Muti find & replace function
    By junada0 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-04-2010, 02:34 AM
  6. How to find and replace with function?
    By yannipr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2008, 07:27 AM
  7. find and replace function
    By araki in forum Excel General
    Replies: 0
    Last Post: 03-11-2005, 02:33 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