Fix Excel Find and Replace Opening on the Wrong Monitor
Question details
The user wants Excel's Find and Replace dialog to open on the monitor containing the active workbook.
- Product
- Microsoft Excel 2016
- Device & OS
- Windows with multiple monitors
- Scenario
- The user works in Excel on an external monitor while a laptop display is also connected.
- Observed behavior
- The Find and Replace dialog may open on the laptop display instead of the monitor displaying the active workbook.
Connect the monitors you plan to use and identify the one displaying your Excel workbook. In Windows Display settings, select Identify if you need to match the numbered displays to your screens.
Set the Workbook Monitor as the Main Display
Use this Windows workaround to make the monitor where you work in Excel the primary display.
Right-click an empty area of the Windows desktop and select Display settings.
Under the display arrangement, select the numbered monitor where you want the Find and Replace dialog to appear. Select Identify if you are unsure which number to choose.
Expand Multiple displays if necessary, then select Make this my main display.
Return to Excel on the selected monitor and press Ctrl+F or Ctrl+H to open the Find or Replace dialog.
Use a Window-Management Utility to Control Dialog Placement
Try a third-party utility if you want to manage window placement without changing the primary display.
Use WPS Spreadsheets as an Excel Alternative
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility. Open existing workbooks in WPS Spreadsheets for an easier transition, though it does not change Excel's dialog placement.

Frequently Asked Questions
Why does Excel's Find and Replace dialog open on another screen?
Some Excel versions, including Excel 2016, can place the dialog on a different monitor from the workbook. The dialog may also appear on a display with available space when the Excel window fills another screen.
How do I find out which monitor is my main display?
Right-click the Windows desktop and select Display settings. Select each numbered display and check the Make this my main display option under Multiple displays.
Will changing the main display affect other apps?
Yes. The main display is a Windows-wide setting, so changing it can affect where Windows and other applications appear.
Can I control the dialog location without changing my main display?
You can try a third-party window-management utility with placement rules. Open its settings and check whether it can assign Excel's Find and Replace dialog to a specific monitor.




