Office Settings & Configuration

How to Fix Search or Replace Dialog Box Missing in Excel 2021

Chanuka Geekiyanage Oct 15, 2026 869 views

Question details

The user is unable to access the Search or Replace dialog box in Microsoft Excel 2021 because it fails to appear.

How to Fix Search or Replace Dialog Box Missing in Excel 2021

Product: Microsoft Excel 2021 (Office LTSC Professional Plus)
Device & OS: not provided
Scenario: Attempting to use the Find or Replace feature to locate and modify data within a spreadsheet.
Observed behavior: The Search or Replace dialog box does not show up on the primary screen; it may be experiencing a software glitch or opening off-screen.

Before you start

Before attempting software repairs, press 'Alt + Space', then tap 'M' on your keyboard, and use your arrow keys to see if you can drag an off-screen dialog box back into your main display view.

Solution 1Recommended

Start Excel in Safe Mode and Disable Problematic Add-ins

Running Excel in Safe Mode prevents third-party add-ins from loading, which helps identify if an external plugin is blocking the dialog box.

Third-party COM add-ins or macros can sometimes conflict with Excel's core features, causing graphical glitches like hidden dialog boxes. Safe mode allows you to isolate the root cause.

Open the Run Command

Right-click on the Windows Start button and select 'Run', or press the Windows Key + R on your keyboard.

Launch Excel in Safe Mode

Type 'excel /safe' into the Run dialog box and click 'OK'.

Test the Find Feature

Press 'Ctrl + F' in Safe Mode. If the Search or Replace dialog appears correctly, an add-in is likely causing the issue.

Disable Add-ins

Go to File > Options > Add-ins. At the bottom, change the 'Manage' dropdown to 'COM Add-ins' and click 'Go'. Uncheck the add-ins to disable them, then restart Excel normally to see if the issue is resolved.

Start Excel in Safe Mode and Disable Problematic Add-ins

Re-enable Add-ins Individually: If disabling all add-ins fixes the problem, re-enable them one by one to pinpoint exactly which add-in is responsible for the missing dialog box.

Solution 2

Run an Office Online Repair

Using the built-in Microsoft Office Repair tool can fix corrupted application files that prevent features from displaying correctly.

Free Microsoft Office alternative

Experience a Seamless Spreadsheet Workflow with WPS Office

If Microsoft Excel continues to experience frustrating glitches like missing dialog boxes, consider switching to WPS Office. It is a highly compatible, free, and lightweight alternative offering a robust and stable Spreadsheets application with a familiar layout.

1. Download the Free Suite: Visit the WPS Office website and download the installation package for your PC.
2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx document directly without worrying about formatting loss.
3. Use Find and Replace Effectively: Press Ctrl + F to bring up the Search and Replace dialog instantly, allowing you to edit your data without interruption.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csvStable and lightweight alternative without frequent UI or dialog box glitchesBuilt-in reliable Find and Replace tools that work seamlessly out of the boxFamiliar interface ensures zero learning curve when migrating from Microsoft Office

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel Find and Replace box open off-screen?

This commonly occurs if you recently disconnected a second monitor, changed your screen resolution, or used a docking station while the dialog box was open. The operating system remembers the previous screen coordinates of the window, placing it outside your current display area.

Is there a keyboard shortcut to bring an off-screen window back into view?

Yes. Ensure Excel is the active window, press 'Ctrl + F' to trigger the dialog, then press 'Alt + Space' followed by 'M' (for Move). Press any arrow key once, and then move your mouse. The hidden dialog box will attach to your cursor so you can drop it onto your visible screen.

Will reinstalling Microsoft Office 2021 fix missing interface elements?

Reinstalling often resolves corrupted file issues, but running an 'Online Repair' from the Control Panel is generally faster and accomplishes the same result without requiring you to manually uninstall and reactivate the entire Office suite.

Office App Problems