How to Get Rid of the Search Bar in Excel

To hide Excel’s large Search box in Microsoft 365 for Windows, go to File > Options > General, then select Collapse the Microsoft Search box by default. This collapses the box to a small search icon; Excel does not offer a supported setting to remove that icon entirely. If you mean the Find pane over your worksheet instead, close it with its X.

Excel has more than one feature people call the search bar. The Search box sits near the top of the app and searches for commands, help, and other items. The Find pane appears when you look for text or numbers in a workbook. The steps below explain how to handle each one, plus what to expect in Excel for Mac and Excel for the web.

What You’ll Need

Excel for Microsoft 365 on Windows if you want to change the top Search box setting.
Permission to change Excel’s application options. The setting affects the Excel interface on your computer, not the contents of a particular workbook.
If the unwanted search control is inside a worksheet, the workbook open in Excel so you can identify whether it is a Find pane, a filter search field, or a form control.

Step-by-Step

Identify which search bar you want to hide. Look at where it appears. A wide box in the Excel title area, usually near the top of the window, is Microsoft Search. A pane or dialog that appears after searching for a word is Find. A search field inside a table’s filter menu or on the worksheet itself belongs to that workbook feature. Choosing the right fix matters: changing the top Search box setting will not close Find or remove a worksheet control.
Collapse the top Search box in Excel for Microsoft 365 on Windows. Select File in the upper-left corner, then select Options near the bottom of the left-hand menu. In the Excel Options window, open General. Under User Interface options, select the checkbox labeled Collapse the Microsoft Search box by default. Select OK to apply the change. If the box is currently expanded, close and reopen Excel if it does not collapse immediately.
Check the result and understand what remains. The long Search box should be replaced by a compact magnifying-glass or Search icon. Selecting that icon opens Search when you need it. This is a way to reclaim title-bar space, not a complete removal of the search feature. The setting applies to Excel’s interface on that computer, so you may need to change it again on another device or Windows profile.
Close the Find pane if it is the worksheet search you mean. If you searched for a value and a pane appeared along the side of the workbook, select the X in the pane’s upper corner. If Excel displays a Find and Replace dialog instead, select Cancel or its close button. Closing the pane or dialog does not delete the value you searched for or alter the cells.
Reopen Find only when you need it. In desktop Excel for Windows, press Ctrl+F or use Home > Find & Select > Find. On a Mac, use Command+F or the Find command on the ribbon or menu, depending on the version. Search for the value, then close the resulting pane or dialog when finished. The Find controls are temporary; you do not need to change Excel Options to dismiss them.
Check whether the field belongs to a table filter. If the search field appears after you open a column’s filter drop-down, it is part of the filter menu, not the title-bar Search box. Close the menu by clicking elsewhere or pressing Esc. To show all rows again, open that column’s filter menu and choose Clear Filter or select all listed values, as appropriate. This changes which rows are displayed; it does not remove the column or its data.
Inspect a search box placed on the worksheet. A visible field inside the grid may be a text box, a form control, or an ActiveX control added by the workbook’s author. First save a copy if you are unsure what the workbook does. On Windows, open Home > Find & Select > Selection Pane to review objects on the sheet. Select a likely object in the pane to identify it; hide it with the eye icon if available, or select it and press Delete only if you intend to remove it. Removing an input control may break a linked macro or workflow.
Use the alternatives that apply to your version. Excel for Mac does not have the same Windows File > Options > General page. Depending on its release and layout, the top Search control may be compact already or may open from a Search icon; there may be no equivalent preference to remove or collapse it. Excel for the web also keeps its Search control in the app interface and does not provide the Windows collapse setting. You can still close a Find pane or dialog, or exit a filter menu, in those versions.

Common Mistakes

Expecting the icon to disappear completely. The Windows option collapses the Microsoft Search box; it does not uninstall Search or erase every visible search icon. If your goal is to have no Search feature at all, Excel’s normal settings do not provide that option.

Changing the ribbon display instead. Switching between ribbon layouts, such as showing tabs only, can change how much room the ribbon uses, but it is not the same as changing the Search box preference. It may also hide commands you rely on. Use the General option when it is available for the title-area Search box.

Confusing Find with Microsoft Search. The top Search box finds commands and help as well as other items. Find searches the open workbook for cell contents. Closing one does not close the other, so confirm which control is visible before changing settings.

Deleting a worksheet object without checking its purpose. A form field may feed a formula or macro. Hiding it or making a copy of the workbook first is safer than deleting it immediately, particularly in a shared template.

Assuming the setting travels with the workbook. The collapsed Search preference is an application setting, not a workbook property. A coworker opening the same file may still see the expanded Search box if their Excel preference differs.

Tips

Use the title bar as your guide: a persistent, wide box at the top is usually Microsoft Search; a pane that appeared after looking for a cell value is usually Find.
If you rarely use the top Search box, collapsing it keeps the command available without taking up as much room. You can still open it from its icon when needed.
When you need to find text in cells, use Ctrl+F on Windows or Command+F on Mac. To search for formulas, values, or comments, check the Find options so Excel searches the kind of content you expect.
Before changing a workbook object, save a separate copy. This is especially useful for files with buttons, macros, dashboards, or custom data-entry forms.
If you are working on a small screen, hiding or collapsing the ribbon may free more space than changing Search. Treat that as a separate display choice, since it affects access to ribbon commands.

Troubleshooting

The checkbox is missing. Confirm that you are using desktop Excel for Microsoft 365 on Windows and that you opened File > Options > General, not a workbook’s settings. Older, managed, or differently updated Office builds can show a different interface. Install available Office updates if permitted, or use the compact Search icon if your build already displays one.

The Search box still looks wide after you selected the option. Select OK to save the preference, then close and reopen Excel. Make sure you changed the option in Excel itself rather than Word or another Office app. If Excel is controlled by workplace policies, an administrator may manage which options are available.

The bar returns on another computer. The preference may not follow your workbook or account. Repeat the Windows steps on that computer if its version offers the setting. Excel for Mac and the web have different interfaces, so the same checkbox may not exist there.

You closed Find, but another search field remains. Look for a second interface element: the Microsoft Search box at the top, a filter drop-down in a table, or an object placed on the sheet. Close the filter menu or use the Selection Pane to inspect worksheet objects. Avoid deleting objects until you know whether the workbook depends on them.

The Search control is not selectable. A title-area Search control is part of Excel’s interface, not a cell or worksheet object, so clicking it and pressing Delete will not remove it. Use the supported collapse preference where available. If the control is in a protected worksheet, you may need the workbook password or the owner’s permission to change worksheet objects.

Frequently Asked Questions

Can I completely remove the Search box from Excel?

In Excel for Microsoft 365 on Windows, the built-in preference collapses the box but leaves a Search icon. Excel does not provide a normal setting to remove the feature entirely. Other versions may show a compact icon by default.

Does collapsing Search change my workbook?

No. It changes the Excel interface on your computer, not the worksheet, formulas, data, or workbook layout. Other people may see a different Search-box layout when they open the file.

How do I get the Search box back after collapsing it?

Use the magnifying-glass or Search icon in the title area to open Search. To change the default on Windows, return to File > Options > General and clear Collapse the Microsoft Search box by default.

Why does Ctrl+F not get rid of the bar?

Ctrl+F opens Find; it does not hide Microsoft Search. If Find is open, close its pane or dialog with the X or Cancel. If the top Search box remains, use the collapse setting on Windows.

Can I hide the Search box in Excel for the web?

Excel for the web does not include the Windows setting for collapsing Microsoft Search. You can close temporary Find or filter menus, but the app’s top Search control remains part of its interface.

Is the Search field in a filter menu the same as Excel Search?

No. A filter-menu field helps narrow the values shown for a particular table or column. Close the menu to dismiss it; use the column’s filter options if you want to change which rows are displayed.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.