NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Spreadsheet basics›Turn off smart fill

Google Sheets · Verified tutorial

Turn off smart fill in Google Sheets

This is a stable Smart Fill settings fixture. Update only B2 from "On" to exactly "Off". Keep Autocomplete on and do not edit the required-value column.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

This is a stable Smart Fill settings fixture. Update only B2 from "On" to exactly "Off". Keep Autocomplete on and do not edit the required-value column.

Step-by-step

1

Select the targetThis is a stable Smart Fill settings fixture.

2

Complete the next actionUpdate only B2 from "On" to exactly "Off".

3

Apply the changeKeep Autocomplete on and.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

Smart Fill is recorded as Off while Autocomplete stays On.

Common mistake

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

Troubleshooting

Re-select B2 and repeat the final action. Smart Fill is recorded as Off while Autocomplete stays On.

Example spreadsheet data

This is the clean fixture used for the verified run.

Setting	Current value	Required value
Smart Fill	On	Off
Autocomplete	On	On

Video transcript

Open the prepared Smart Fill setting spreadsheet.
Select the target. This is a stable Smart Fill settings fixture.
Complete the next action. Update only B2 from "On" to exactly "Off".
Apply the change. Keep Autocomplete on and.
Smart Fill is recorded as Off while Autocomplete stays On.