How to fix a non-working CTRL+F in Excel: 5 Solutions

Below is a dataset representing the 5 best-nominated movies in the Best Picture category for the 2022 Oscar Awards.

Solution 1 –  Set ‘Option’ to Look in Values 


  • Choose the Values or Formulas options and press Find Next.

Set Option to Look in Values to Fix CTRL+F Not Working Problem in Excel

You will see Excel has found the value in the sheet with a green rectangle in the cell.

Solution 2 – Unselect Multiple Cells 


  • Don’t select multiple cells before finding values.
  • Select none or Select one cell.

Then it will work properly.

Solution 3 – Unmark ‘Match Entire Cell Contents’


  • Unmark ‘Match Entire Cell Contents’.

Excel will be able to find any part from the value of a cell.

Read More: How to Check If a Value is in List in Excel

Solution 4 – Remove an Extra Space 


  • Remove any extra spaces and apply the CTRL+F command. It will work properly.

Solution 5 – Unprotect the Worksheet


  • Click Home > Cells > Format > Unprotect Sheet.

  • Enter the password and press OK.

You will be able to use the CTRL+F command.

Download the Practice Workbook

You can download the free Excel template and practice on your own.

Related Articles

<< Go Back to Find Value in Range | Excel Range | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Sourov Hossain Mithun
Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF