A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Dear @Hailong MC (EX),
I completely understand how frustrating this is. When you are trying to stay productive across multiple screens, having an Excel window suddenly collapse into a tiny title bar stub (as shown in your screenshot) completely breaks your workflow.
This issue is not a bug in Excel; it is a known behavior caused by a feature in Windows 11/10 called Snap Assist, combined with a mismatch in display scaling or resolution between your two monitors. When you drag the window across the threshold, Windows miscalculates the window boundaries on the second screen and collapses it.
Here are the two quickest ways to resolve this issue:
Fix 1: Turn off "Snap Assist" Window Shaking
Windows has a feature were dragging or shaking a window can minimize everything else or automatically resize it incorrectly across monitors.
- Press the Windows Key + I to open Settings.
- Go to System > Multitasking.
- Click on the Snap windows dropdown to expand the options.
- Uncheck the box that says: "When I drag a window, let me snap it without dragging all the way to the screen edge" (or turn off Title bar window shake if available in your build).
Fix 2: Match the Display Scaling Between Monitors
If your monitors have different scaling settings (e.g., Laptop screen is at 150% and the external monitor is at 100%), Windows often minimizes or shrinks Excel during the transition.
- Right-click on an empty space on your desktop and select Display settings.
- Click on Monitor 1 and look down at Scale and layout (note the percentage, e.g., 125%).
- Click on Monitor 2 and set it to the exact same scaling percentage as Monitor 1.
If you need to move the sheet immediately without dragging, select the Excel window and press Windows Key + Shift + Left Arrow (or Right Arrow). This instantly snaps the full window to the next screen without triggering the dragging minimization.
Please try these steps and let me know if the window stops collapsing for you.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.