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

Google Sheets tutorials›Spreadsheet basics›Create a numbered list

Google Sheets · Verified tutorial

Create a numbered list in Google Sheets

Create the series 1, 2, 3, 4 in A2:A5 using autofill.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Create the series 1, 2, 3, 4 in A2:A5 using autofill.

Step-by-step

1

Select the targetCreate the series 1, 2, 3, 4 in A2:A5.

2

Apply the changeautofill.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

A2:A5 contains 1 through 4.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A2:A5 and repeat the final action. A2:A5 contains 1 through 4.

Example spreadsheet data

This is the clean fixture used for the verified run.

Step

1

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Create the series 1, 2, 3, 4 in A2:A5.
Apply the change. autofill.
A2:A5 contains 1 through 4.