Fix Blank Results and Calculated Columns in Excel Power Query Output
Question details
Return a blank when a source cell is empty and prevent Excel from applying an edited formula to an entire table column.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- The user is calculating values from source columns and editing formulas in a Power Query output table.
- Observed behavior
- A calculation needs to remain blank when its source cell is empty, and Excel automatically fills a table column when a formula is edited.
Check whether the calculation is a worksheet formula or part of a Power Query output table. For a query, confirm the source column names and whether empty values appear as null or empty text.
Return a Blank with an Excel Worksheet Formula
Use an IF formula when the calculation is performed in a worksheet cell.
Select the result cell and enter =IF(G1="","",G1-F1). Adjust the row and column references to match your data.
Leave G1 empty to confirm the formula displays a blank; enter a value in G1 to calculate G1 minus F1.
Create the Calculation in Power Query
Use a custom query column to apply the calculation consistently when the output refreshes.
Stop Excel from Filling the Entire Calculated Column
Use this when editing one formula causes Excel to fill the table column automatically.
Work with Spreadsheet Formulas in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier transition. Use WPS Spreadsheets for worksheet formulas; it does not fix Excel Power Query behavior.

Frequently Asked Questions
How do I make an Excel formula show blank when G1 is empty?
Enter =IF(G1="","",G1-F1) in the result cell. The formula returns an empty text string when G1 is empty.
Will a Power Query custom column remain after refresh?
Yes. Add the calculation through Add Column > Custom Column in Power Query Editor, then select Home > Close & Load. The query reapplies the transformation when refreshed.
How can I stop Excel from copying a formula down a table column?
Immediately after the automatic fill, use Undo or select the AutoCorrect Options button and choose Stop Automatically Creating Calculated Columns.
Is an Excel formula blank the same as a Power Query null?
No. The worksheet formula =IF(G1="","",G1-F1) returns an empty text string, while a Power Query custom column can return null.
Will manually entered data stay aligned with Power Query rows?
Not necessarily. A refresh can change the query output, so manually added worksheet data may no longer correspond to the same rows. Where possible, add the calculation in Power Query instead.





