You are entering a formula in Excel and the Function Arguments dialog box appears off-screen. You cannot see the OK or Cancel buttons to finish your work. This happens when the dialog opens at a screen position saved from a different monitor setup. This article explains how to move the dialog box back into view using keyboard shortcuts and Windows settings.
Key Takeaways: Moving the Function Arguments Dialog Box
- Alt + Space, then M, then Arrow Keys: Activates the Windows move command to reposition any off-screen dialog with your keyboard.
- Windows Snap Assist or Task View: Use Windows 11 or Windows 10 window management features to pull the dialog onto your current screen.
- Changing Display Scaling or Resolution: Adjusting your monitor settings can force all windows to reset their positions to the visible desktop area.
Why the Function Arguments Dialog Disappears
The Function Arguments dialog box is a modal window. This means it must be closed before you can interact with the main Excel window again. Excel remembers the last screen position where this dialog was closed. If you disconnect a secondary monitor or change your display resolution, the saved coordinates may place the dialog outside your current visible desktop area. The dialog is still running, but its title bar and controls are inaccessible because they are not on any active display.
How Excel Stores Window Positions
Windows applications, including Excel, store window location data in the Windows Registry or in temporary memory for the current session. This data includes X and Y coordinates for the top-left corner of the window. When you launch the Function Arguments dialog, Excel uses these stored coordinates. If those coordinates correspond to a monitor that is no longer connected, the dialog renders in a virtual space you cannot see. This is a common issue with multi-monitor setups and docking stations.
Steps to Move the Dialog Box Back On Screen
Use these methods to regain control of the off-screen Function Arguments dialog. Start with the keyboard method as it works directly on the hidden window.
Method 1: Use the Windows Move Keyboard Shortcut
- Ensure the dialog is the active window
Click on the Excel formula bar or press Alt + Tab until you feel the focus is on the missing dialog. You may hear a system sound indicating a window is active. - Press Alt + Space, then M
This key combination opens the system menu for the active window and selects the Move command. Your mouse cursor will change to a four-directional arrow. - Use the Arrow Keys to move the window
Press any arrow key once to engage move mode. Then, without clicking the mouse, use the arrow keys to shift the window. You will see it appear on your screen as you move it. - Press Enter or click the mouse
Once the dialog is in a good position, press the Enter key to lock it in place. Alternatively, you can now click the left mouse button.
Method 2: Use Windows Display and Task View Features
- Open Windows Task View
Press the Windows key + Tab. This shows all open windows, including the off-screen Excel dialog. - Drag the dialog preview to your main screen
In the Task View, find the preview for the Function Arguments dialog. Click and drag that preview thumbnail down to the virtual desktop representation of your primary monitor at the bottom of the screen. - Use Windows Snap Assist
If you can see a thin edge of the dialog, hover your mouse over it until the cursor changes. Then drag the window. In Windows 11, you can also press Windows key + Z to see snap layouts and potentially pull the window into a zone.
If the Dialog Box is Completely Inaccessible
Sometimes the window is so far off-screen that the keyboard shortcut does not work. In these cases, you need to change the environment to reset all window positions.
Excel Crashes When the Dialog is Off-Screen
If Excel becomes unresponsive because you cannot cancel the modal dialog, force it to close. Press Ctrl + Shift + Esc to open Task Manager. Find the Microsoft Excel entry, select it, and click End Task. Be aware you will lose unsaved work. Before reopening Excel, change your display settings as below to prevent a repeat.
Change Display Scale or Resolution to Reset Windows
- Right-click your desktop and select Display settings
This opens the Windows Settings app to the system display page. - Change the Scale or Resolution setting temporarily
Under Scale & layout, choose a different scale percentage like 125%. Or change the Display resolution to a different value. Apply the change. - Check Excel and revert the setting
The change will force all windows to reposition. Check if the Excel dialog is now visible. You can then change the scale or resolution back to your preferred setting.
Keyboard Shortcut vs. Display Settings: Key Differences
| Item | Keyboard Shortcut (Alt+Space, M) | Changing Display Settings |
|---|---|---|
| Primary use | Reposition a specific off-screen window | Reset positions for all application windows |
| Speed | Fast, direct control | Slower, requires system changes |
| Risk of data loss | None | Low, but may close unsaved work if apps restart |
| Best for | Single missing dialog in an active session | Persistent window placement issues across multiple apps |
| Technical skill required | Basic keyboard knowledge | Comfort with system settings |
You can now retrieve the Function Arguments dialog when it moves off your screen. The Alt + Space, M shortcut is the most reliable fix for this specific Excel problem. For recurring issues, check your Windows display configuration before opening Excel. A more advanced tip is to use a utility like Microsoft PowerToys FancyZones to create and manage fixed window positions, preventing dialogs from drifting off-screen in multi-monitor setups.