An array formula needs enough clear cells for its output. If it cannot expand, inspect the destination area before changing the calculation or clearing data.
Estimate the result’s shape
Read the formula’s source ranges and expected number of output rows and columns. A formula returning several columns requires clear space to the right as well as below its starting cell.
Inspect the detailed error for the blocked location. A cell that looks empty may contain a formula returning an empty string, a space, or part of a merged area.
Create a safe output area
Move the array formula to an unused test area, or preserve and relocate genuine obstructions. Do not delete a large region simply because it sits below the formula. If merged cells intersect the output, review and resolve that layout deliberately.
Keep paired ranges compatible in height and width. ARRAYFORMULA does not make every function accept arbitrarily mismatched inputs, and some functions already return expanding arrays without an added wrapper.
Check coverage and future growth
Verify the first and last output records and compare their count with the intended input population. Check whether blank source rows should produce blank outputs or calculated values.
Leave a clearly designated output area so later editors do not type into the spill region. For growing datasets, plan bounded ranges with enough room or a reviewed expansion strategy. Excessive whole-column arrays can increase calculation work, so avoid extending the output far beyond useful data merely to prevent future maintenance. After moving a formula, inspect downstream references too; an array that expands successfully can still be in the wrong location for a report expecting its previous address.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.