New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Errors›Array result was not expanded error

Google Sheets · Verified tutorial

Array result was not expanded error in Google Sheets

A2 cannot expand because A3 contains a blocking value. Clear only A3, then enter exactly =SEQUENCE(3) in A2.

Verified by JosephineJuly 25, 2026About 75 seconds

Quick answer

A2 cannot expand because A3 contains a blocking value. Clear only A3, then enter exactly =SEQUENCE(3) in A2.

Step-by-step

1

Select the targetA2 cannot expand because A3 contains a blocking value.

2

Complete the next actionClear only A3.

3

Apply the changeenter exactly =SEQUENCE(3) in A2.

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

A2:A4 contains the expanded sequence 1, 2, 3.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select A2 and repeat the final action. A2:A4 contains the expanded sequence 1, 2, 3.

Example spreadsheet data

This is the clean fixture used for the verified run.

Sequence

Blocking value

Video transcript

Open the prepared Array recovery spreadsheet.
Select the target. A2 cannot expand because A3 contains a blocking value.
Complete the next action. Clear only A3.
Apply the change. enter exactly =SEQUENCE(3) in A2.
A2:A4 contains the expanded sequence 1, 2, 3.