Fix Blank Conditional Column Dialog in Excel Power Query
Question details
The Conditional Column and Invoke Custom Function dialogs open as blank windows in Excel Power Query, preventing users from making configurations.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user is trying to add a conditional column or invoke a custom function within the Power Query Editor.
- Observed behavior
- The expected configuration dialog boxes appear completely blank, making it impossible to see options or continue working, even if Office is fully updated.
Make sure to save your current Excel workbook to avoid losing any recent data or query progress in case you need to restart the application completely.
Use Keyboard Shortcuts to Close the Dialog and Restart
Quickly bypass the unresponsive blank dialog using specific keyboard shortcuts, then restart the Power Query Editor to restore functionality.
When the Power Query dialog interface crashes or fails to render, the window is still active but invisible. You can use standard Windows keyboard shortcuts to dismiss the broken window without force-quitting the entire Excel application.
Click anywhere inside the blank window to ensure that it has the active focus.
Press the 'Esc' key on your keyboard. If the window does not close, press 'Alt + F4' instead. Depending on your system state, only one of these shortcuts may work.
Once the blank window is dismissed, close the Power Query Editor entirely and then reopen it to see if the interface loads correctly.
If reopening the editor doesn't fix the rendering, save your file, close Microsoft Excel completely, and relaunch the application.
Update and Repair Microsoft Office
Resolve underlying software glitches or corrupted installation files by applying the latest Microsoft 365 updates or running an Office repair.
Experience Stable Data Processing with WPS Office
If Microsoft Excel continues to experience frustrating UI glitches like blank Power Query dialogs, consider trying WPS Office. It provides a lightweight, highly stable environment for all your spreadsheet needs without the heavy resource usage.

Frequently Asked Questions
Why do Power Query dialogs suddenly go blank in Excel?
This is a known rendering bug in Microsoft Excel that can be triggered by display driver conflicts, limited system resources, or certain Windows updates disrupting the Office UI engine.
Will I lose my unsaved query steps if the dialog freezes?
If you are forced to shut down Excel via Task Manager, unapplied query steps may be lost. Using the Esc or Alt+F4 keys allows you to close just the broken dialog, safely preserving your unsaved work in the editor.
Does disabling hardware graphics acceleration fix the blank dialog issue?
Sometimes. Disabling hardware acceleration in Excel (via File > Options > Advanced > Display) can occasionally resolve UI rendering issues, though newer versions of Office have removed this manual toggle, making updating the software the preferred solution.




