How to Get the Search Bar Back in Excel: Quick Fixes

To restore the main Search box in Excel for Microsoft 365 on Windows, open File > Options > General, find User interface options, and clear Collapse the Microsoft Search box by default. If you only need to search cells, press Ctrl+F instead. These are two different search features, so first identify which one has disappeared.

The main Search box is usually in the title bar near the top of Excel. It helps you find commands, features, help, and sometimes workbook content. The Find feature searches worksheet cells. The formula bar, which displays or edits the selected cell’s contents, is a third, separate part of the interface. The steps below focus on restoring the main Search box first, then explain what to do if you meant worksheet search.

What You’ll Need

Excel for Microsoft 365 on Windows, with the workbook open. You may use a blank workbook if you only want to check the interface.
Permission to change Excel’s application options. These settings affect Excel on your computer, not the contents of a particular workbook.
If Excel is managed by your workplace or school, you may need an administrator to check whether an organization policy controls the Search box.

Step-by-Step

Check whether the box is collapsed rather than gone. Look along the top of the Excel window, particularly around the title bar. Depending on the Microsoft 365 update and window size, Search may appear as a long box, a shorter box, or a magnifying-glass icon. Click the magnifying glass if it is there. If a search field opens, the feature is available; it was just displayed compactly.
Open Excel Options. Select File in the ribbon, then select Options near the bottom of the Backstage screen. If the window is too narrow to show the word Options clearly, maximize Excel and check the lower part of the File menu again. This opens settings for the Excel application, not settings for an individual sheet.
Go to the General settings. In the Excel Options window, select General in the left-hand list. Look for the section labeled User interface options. The exact placement or wording can vary slightly between Microsoft 365 builds, but the setting is in General, not in the worksheet’s View options.
Uncollapse the Microsoft Search box. Find Collapse the Microsoft Search box by default. If its checkbox is selected, clear it. This setting tells Excel to show the full Search box rather than keeping it minimized by default. If the checkbox is already clear, leave it as it is and continue to the next step.
Save the change. Select OK at the bottom of Excel Options. Return to the workbook and inspect the top of the window. In many builds, the Search box expands immediately. If it does not, close and reopen Excel, then check again.
Use the keyboard shortcut if you need Search right away. Press Alt+Q on Windows to focus the Search box or open its command-search interface. Type a command such as Freeze Panes or Page Layout to find an Excel command. This is a useful workaround while you check the display setting; it does not necessarily change whether the full box stays expanded.
If you meant to find text in cells, open Find instead. Press Ctrl+F on Windows, type the word, number, or phrase, and press Enter or choose Find Next. You can also use Home > Find & Select > Find. In the Find window, select Options if you need to choose whether Excel searches the current sheet or the whole workbook, or searches values, formulas, or other content.

Once the main Search box is visible, you can use it to locate Excel commands and features without browsing through ribbon tabs. For example, typing Print Area can surface related commands, while typing a question can offer help results. A command search is not the same as a search through every cell in your workbook, so use Find when you need to locate a particular entry in a table or worksheet.

Common Mistakes

Confusing Search with Find. The title-bar Search box is mainly for commands, features, and help. Ctrl+F opens Find for worksheet content. Restoring one does not necessarily restore the other, and using Ctrl+F is not proof that the main Search box is visible.
Looking in the wrong settings area. The option to collapse the Microsoft Search box is under File > Options > General. Searching the View tab for a Search box switch can waste time because View controls worksheet and window display features, not this General preference.
Changing the formula bar setting by accident. The formula bar is the line below the ribbon where Excel shows the active cell’s contents. On Windows, its visibility is controlled from View > Show > Formula Bar. Turning that on will not bring back the title-bar Search box, and turning it off does not disable Find.
Expecting Alt+Q to expand the box permanently. Alt+Q is a quick way to invoke Search, but it is a shortcut, not a replacement for changing the collapse preference. If the box returns to a compact icon after you close the search interface, revisit the General setting.
Changing the setting in a different Office app. Excel’s Options apply to Excel. Changing Word or Outlook preferences will not necessarily affect the Search display in Excel, even though those apps also have Microsoft Search features.
Assuming the workbook is damaged. The Search box is part of Excel’s interface and does not belong to a particular sheet or file. A missing box is usually a display preference, a window layout issue, or an app or organization policy—not a problem with the workbook’s data.

Tips

Try Alt+Q before changing anything. If Search opens, Excel can still access the feature, and you can use the shortcut for commands while deciding whether you want the full box displayed all the time.
Maximize the Excel window. A narrow window can make title-bar elements appear condensed or move interface items into a smaller layout. Maximizing the window helps you tell whether the Search box is hidden, collapsed, or simply displayed differently.
Use Find options for a broader workbook search. In the Find window, choose Within: Workbook when you want to look across sheets. If you leave it set to Sheet, Excel may find a match on the active worksheet but not on another tab. Check Look in as well if a formula result is visible but Find is not locating it as expected.
Remember the Mac shortcut is different. In Excel for Mac, press Command+F to find worksheet content. The Windows path through File > Options does not apply because Mac has a different settings interface. Search-box availability and placement can also vary by Mac release.
In Excel for the web, use the browser version’s own controls. Excel for the web runs in a browser and does not have the Windows Excel Options dialog. Use the Excel ribbon’s search or Find controls if available, and use the browser’s page-search command only when you intend to search visible page text rather than workbook cells.
Restart only after saving your work. If Excel does not redraw its title bar after you change the setting, save the workbook and restart the app. A restart is a display refresh step; it should not be needed for every change, and it cannot recover unsaved edits if Excel closes unexpectedly.

Troubleshooting

The checkbox is missing. Confirm that you opened the desktop Excel app and went to File > Options > General, rather than opening Excel in a browser. Microsoft sometimes adjusts wording or layout between updates. Look for a setting mentioning the Microsoft Search box or its collapsed state. If there is no related option in your build, use Alt+Q to access Search and check whether an Office update is available.

The box is still a magnifying glass after you cleared the option. Click the icon once to see whether it expands, then select OK in Options if you have not already done so. Maximize Excel and close any pop-up or backstage screen. If the display does not change, save your workbook, exit Excel completely, reopen it, and check the title bar again. Also verify that you cleared the checkbox rather than selected it: the wording describes collapsing the box, so a checked box favors the compact display.

Alt+Q does nothing or opens a different control. Make sure the Excel window is active and not a dialog box, another app, or a browser tab. Click in the workbook and try the shortcut again. Some keyboard layouts, remote-desktop setups, or system-level shortcuts can affect key combinations. You can still look for the Search control at the top of the window and use the File menu to inspect the setting.

Search opens, but it does not find cell contents. That is expected if you are using the command Search box. Use Ctrl+F or Home > Find & Select > Find instead. In Find, select Options, set Within to Workbook if necessary, and check the Look in choice. For example, a cell containing a formula may display a result; changing Look in can affect whether Excel searches the formula itself or the displayed value.

The Search box looks different on a Mac or in a browser. Do not follow Windows-only instructions for File > Options on those platforms. Mac Excel has its own app preferences and may show Search differently depending on its release. Excel for the web is updated separately and has no desktop Options dialog. If your goal is simply to search worksheet entries, use Command+F on Mac or the Find control in the web app, rather than trying to restore the Windows title-bar box.

A work or school device keeps reverting the setting. Your Microsoft 365 administrator may manage Office interface preferences, and policies can override local choices. If the setting is visible but will not stay changed, contact your organization’s support team and describe the setting you changed. Avoid editing Windows Registry values or downloading unofficial tools to force the Search box to appear; those workarounds can affect other Office settings and may violate device policies.

Frequently Asked Questions

How do I get the Search bar back in Excel quickly?
On Windows, press Alt+Q to open or focus Search. To keep the full box displayed, clear Collapse the Microsoft Search box by default under File > Options > General, then select OK.

Why did my Excel Search bar turn into a magnifying glass?
Excel may be displaying the Microsoft Search box in its collapsed form. Click the magnifying-glass icon to open it, or clear the collapse checkbox in General options if you prefer the full box by default.

Does Ctrl+F bring back the Search bar?
No. Ctrl+F opens Find, which searches cell contents. It is a convenient alternative when you need to locate text in a sheet, but it does not change the display of the main Search box.

How do I restore the formula bar instead?
In Excel for Microsoft 365 on Windows, select View > Show > Formula Bar. The formula bar displays the contents of the selected cell; it is separate from both the title-bar Search box and the Find window.

Can I search every worksheet at once?
Yes. Open Find with Ctrl+F, select Options, and set Within to Workbook. If Within is set to Sheet, Excel searches only the active worksheet.

Are the same steps available in Excel for Mac?
No. The Windows File > Options path is specific to desktop Excel for Windows. On Mac, use Command+F to find worksheet content and check the Mac app’s own preferences for available interface options; the Search box layout can differ by version.

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.