Office Settings & Configuration

How to Keep the Excel Find and Replace Window Visible After No Results

Amos GikundaAmos Gikunda Nov 13, 2026 869 views

Question details

The user needs to capture both the Excel Find and Replace dialog and the no-results alert in Excel 2019 or Excel 2021, but Excel may hide the dialog while the alert is displayed.

Keep the Excel Find and Replace Window Visible After No Results
Product
Microsoft Excel 2019/2021
Device & OS
not provided
Scenario
The user is documenting or creating a screenshot of a Find and Replace operation and wants both the dialog box and the no-results alert visible at the same time.
Observed behavior
Excel temporarily hides the Find and Replace window while the no-results alert is displayed, preventing a single screenshot that contains both windows.
Before you start

Open the Excel workbook that contains the data you need to search, and identify the search text and the target column or range before you open the Find and Replace dialog.

Solution 1Recommended

Force the Find and Replace Window to Reappear Next to the No-Results Alert

Use this workaround when Excel hides the Find and Replace dialog after a Find All search returns no results and you need both windows visible for one screenshot.

1
Open Find and Replace and enter the search text

In Excel, press Ctrl+F or go to Home > Find & Select > Find. Type the search text in the Find what box and select the target column or range.

2
Run Find All

Click Find All to search the selected range or worksheet for the text.

3
Click outside the Excel application

When the no-results alert appears and the Find and Replace window disappears, click any empty area outside the Excel application window, such as the desktop or another app.

4
Return to Excel and capture both windows

The Find and Replace window should reappear beside the alert. Arrange the two windows as needed and take the screenshot.

Force the Find and Replace Window to Reappear Next to the No-Results Alert
If the dialog does not return: Use Alt+Tab to switch back to Excel, or click the Excel icon on the taskbar, then click outside Excel once more.
Free Microsoft Office alternative

Use WPS Office Spreadsheets for Easier Find and Replace Capture Workflows

If you frequently document or screenshot Find and Replace workflows, WPS Office is a free, lightweight Microsoft Office alternative. It opens .xlsx and .xls files, preserves formatting, and offers a familiar spreadsheet interface so you can migrate from Excel seamlessly.

  1. 1. Download WPS Office: Go to the official WPS Office website and download the free installer for your Windows, macOS, Linux, iOS, or Android device.
  2. 2. Open your Excel workbook in WPS Spreadsheets: Launch WPS Office, click Open, and choose the .xlsx or .xls file you need to work with.
  3. 3. Use Find and Replace in WPS Spreadsheets: Press Ctrl+F or go to Home > Find & Select > Find to open the Find and Replace dialog and run your searches.
Free, lightweight alternative to Excel for everyday spreadsheet tasksOpens and saves .xlsx, .xls, and .csv files with high Microsoft Office compatibilityFamiliar ribbon interface and spreadsheet tools make migration from Excel easierReliable built-in Find and Replace dialog for search demonstrations and screenshots
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Excel Find and Replace window disappear when there are no results?

Excel brings the no-results alert to the foreground and may temporarily hide the Find and Replace dialog. Clicking outside Excel or using Alt+Tab can bring the dialog back.

Can I take one screenshot that shows both the Find and Replace dialog and the no-results alert in Excel?

Yes. Click Find All, and when the alert appears, click anywhere outside the Excel application. The Find and Replace window should reappear beside the alert so you can capture both.

Does this workaround work in Excel 2019 and Excel 2021?

The workaround is reported for Excel 2019 and Excel 2021. If the dialog still does not reappear, use Alt+Tab or capture separate screenshots.

What should I do if clicking outside Excel does not bring the Find and Replace window back?

Use Alt+Tab to cycle to Excel, click the Excel icon on the taskbar, or click the Excel window and then click outside it again. If it still stays hidden, capture the dialog and alert separately.

Can WPS Office open my Excel workbook and use Find and Replace?

Yes. WPS Office Spreadsheets opens .xlsx and .xls files and provides a Find and Replace dialog, so you can perform the same search with a familiar interface.