How to Find and Repair an Excel Search Box Formula in WPS Office
Question details
The user needs to locate and correct a search box formula in an Excel workbook that is not searching the intended rows or columns.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user created a search box in an Excel workbook from an online tutorial, but it is not searching the intended rows or columns, and the formula cannot be located for correction.
- Observed behavior
- The search box returns results from the wrong rows or columns, and the underlying formula is not visible or easily found.
Open the workbook in WPS Office Spreadsheets and make sure the Formulas tab is available. If the workbook contains macros, enable editing and macro content only when the file is from a trusted source.
Locate the Search Box Formula with the Formula Bar and Name Manager
Use this first to find worksheet formulas or named ranges that drive the search box.
Search boxes created with worksheet formulas are usually stored in a specific cell, often hidden or formatted to look like a search field. If the formula uses named ranges, the actual search range may be defined in Name Manager rather than directly in the cell.
Click the search box in the worksheet, then look at the formula bar above the grid. If the formula bar is empty, the search box may be a form control or linked picture, not a worksheet formula.
Go to the Formulas tab and click Name Manager. Look for names used by the search formula, such as SearchList, SearchRange, or similar, and check the Refers To range.
Correct the formula in the formula bar, or select the named range in Name Manager and update its Refers To box to cover the intended rows and columns.

Check Form Controls and VBA Code for the Search Box
Use this when nothing appears in the formula bar or the search box was created as a control or macro.
Repair the Search Formula Range References
Use this to correct formulas that target the wrong rows or columns after you locate them.
Find and Repair Excel Search Box Formulas in WPS Office Spreadsheets
Open the Excel workbook in WPS Office Spreadsheets and use the formula bar, Name Manager, and VBA tools to locate and correct the search box formula without losing your .xlsx formatting or data.
- 1. Download and install WPS Office: Visit the official WPS Office download page, run the installer, and launch WPS Office Spreadsheets.
- 2. Open the Excel workbook: Click Menu > Open and select the .xlsx or .xlsm file containing the search box.
- 3. Locate the search formula: Select the search box and check the formula bar, or go to Formulas > Name Manager to inspect named ranges.
- 4. Repair the range or code: Edit the formula or named range, or open Developer > Visual Basic to correct the search macro.

Frequently Asked Questions
Why is the search box formula not showing in the formula bar?
The search box may be a form control, ActiveX control, or a linked picture rather than a cell formula. Right-click the search box and open Properties or Format Object to check the linked cell, or open the VBA editor to see the macro code.
How do I open Name Manager in WPS Office Spreadsheets?
Click the Formulas tab on the ribbon and select Name Manager. It lists all defined names and their Refers To ranges, which commonly control search box formulas.
Where do I find the search code if the search box uses macros?
Enable the Developer tab via File > Options > Customize Ribbon, then click Developer > Visual Basic. Search the modules for keywords such as Search, Find, TextBox, or Change.
The formula searches only one column. How do I make it search another column?
Edit the formula in the formula bar and change the lookup range or column index to the column you want to search. If it uses a named range, update that range in Name Manager.




