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

Google Sheets tutorials›Spreadsheet basics›Fill down

Google Sheets · Verified tutorial

Fill down in Google Sheets

Fill the value from B2 down through B5 using Edit > Fill > Down.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Fill the value from B2 down through B5 using Edit > Fill > Down.

Step-by-step

1

Select the targetFill the value from B2 down through B5.

2

Apply the changeEdit > Fill > Down.

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

B2:B5 all contains 100.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select B2 and repeat the final action. B2:B5 all contains 100.

Example spreadsheet data

This is the clean fixture used for the verified run.

Month	Revenue
January	100
February
March
April

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Fill the value from B2 down through B5.
Apply the change. Edit > Fill > Down.
B2:B5 all contains 100.