How to Keep the Excel Find and Replace Window Visible After No Results
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.

- 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.
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.
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.
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.
Click Find All to search the selected range or worksheet for the text.
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.
The Find and Replace window should reappear beside the alert. Arrange the two windows as needed and take the screenshot.

Capture the Find and Replace Dialog and Alert Separately
Use this alternative when Excel does not restore the Find and Replace window next to the alert and separate captures are acceptable.
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. 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. 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. 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.

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.




