Office Settings & Configuration

Fix Excel Find and Replace Opening on the Wrong Monitor

Aamir Naveed AkramAamir Naveed Akram Nov 22, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

Set the Workbook Monitor as the Main Display

Use this Windows workaround to make the monitor where you work in Excel the primary display.

1
Open display settings

Right-click an empty area of the Windows desktop and select Display settings.

2
Select the monitor

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.

3
Make it the main display

Expand Multiple displays if necessary, then select Make this my main display.

4
Test Find and Replace

Return to Excel on the selected monitor and press Ctrl+F or Ctrl+H to open the Find or Replace dialog.

This changes a Windows setting: Changing the main display affects Windows and other applications, not just Excel. It is a workaround and may not control every dialog.
Free Microsoft Office alternative

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.

Find and replace spreadsheet content in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLS and XLSXFamiliar spreadsheet interface for working with existing filesFree and lightweight Office alternative
microsoft office alternative - wps office

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.