How to Fix “Array Result Was Not Expanded” in Google Sheets

Google Sheets shows “Array result was not expanded” when a formula needs to return multiple cells but something is already occupying its spill range. Clear the full output area—not just the cell showing the error—and the result can expand.

Last verified: July 28, 2026.

What the Error Means#

Functions such as FILTER, SORT, UNIQUE, SEQUENCE, and IMPORTRANGE can return a range of values from one formula cell. Sheets needs empty cells below or beside that formula to display the result.

If any cell in the expected output range contains a value, formula, space, merged cell, or other obstruction, Sheets stops the expansion.

Find the Blocking Cell#

1. Click the formula cell showing the error.
2. Read the error message to find the first cell Sheets says it would overwrite.
3. Select from that cell through the rest of the expected output range.
4. Look for values that appear blank but contain a space or formula.

Clear the Entire Spill Range#

If the cells should be controlled by the array formula:

1. Select the blocked cells, including cells that look empty.
2. Press Delete or use Edit > Delete values.
3. Remove any merged cells from the output area.
4. Leave the formula in the top-left cell.

Do not delete the formula cell itself. When the range is clear, the result should fill automatically.

If You Need to Keep Existing Data#

The output range cannot share cells with manually entered data. Move the data to another area or change the formula so it returns fewer rows or columns.

For a deliberate limit, use a function such as ARRAY_CONSTRAIN or add a filter condition that matches the space you have available. This is safer than repeatedly deleting cells that belong to another workflow.

Common Hidden Blockers#

A single space#

A cell containing one space looks empty but still blocks expansion. Select the range and use Edit > Find and replace to search for a literal space if necessary.

A formula returning an empty string#

A formula such as =IF(A2="","",A2) still occupies the cell. Move it outside the array's spill range.

Merged cells#

Unmerge cells in the output area before testing the array again.

A second array formula#

Two formulas cannot claim the same spill cells. Give each result its own clear range.

Prevent the Error in Shared Sheets#

• Reserve a dedicated output tab for array formulas.
• Keep notes and manual edits outside spill ranges.
• Add a short label above the result instead of typing inside it.
• Leave enough empty rows for the result to grow.
• Check the first blocked cell named in the error before changing the formula.

Google's ARRAYFORMULA reference explains why one formula can populate multiple rows or columns.

Quick Checklist#

• Identify the first cell Sheets says it would overwrite.
• Clear values, spaces, formulas, and merged cells from the full spill range.
• Keep the array formula in its top-left cell.
• Move manual data or constrain the result when the range must be shared.
• Retest with a small synthetic example before editing a production sheet.

Related Google Workspace Fixes#

• Select Multiple Options from a Google Sheets Dropdown
• Why Google Form Responses Are Not Showing in Your Sheet

Get the Add-On#

Obtenir le module gratuitement

Text To Table Converter

Work faster inside Google Forms, Docs, Sheets, and Slides: Install the free Text To Table Converter add-on for quiz building, choice syncing, QR codes, document tools, and more.

Installer gratuitement