Autofill in Google Sheets isn’t working, you drag the fill handle but nothing happens, patterns aren’t recognized, or values repeat incorrectly.
This usually shows up as static copies instead of series (1,2,3…), broken formulas, or no fill at all.
This guide fixes it step by step.
Why the Issue Happens
- Autofill drag not enabled or blocked by UI/browser
- Only one value selected (no pattern to detect)
- Data type issues (text instead of number/date)
- Formulas using absolute references (
$) incorrectly - Inconsistent pattern (Sheets can’t detect logic)
- Protected ranges preventing edits
- Merged cells blocking fill
- Large dataset or browser lag
Step-by-Step Fixes
Step 1: Use the Fill Handle Correctly
Autofill requires dragging the small blue square at the bottom-right of the cell.
Fix:
- Click the cell
- Hover until you see the + cursor
- Drag down or across
If nothing happens:
- Try double-clicking the fill handle (auto-fills based on adjacent data)
Step 2: Provide a Detectable Pattern
If you enter only one value, Sheets copies it instead of creating a series.
Wrong:
1 → drag → 1,1,1
Correct:
1, 2 → drag → 3,4,5
Sheets needs at least two values to detect a sequence.
Step 3: Fix Text vs Number Issues
If numbers are stored as text, autofill won’t increment.
Example:
- “1”, “2” (text) → won’t continue series
Fix:
=VALUE(A2)
Or:
- Format → Number
Step 4: Fix Date Autofill Issues
Dates may not increment properly if stored as text.
Fix:
=DATEVALUE(A2)
Then drag to continue date series.
Step 5: Check Formula References
If formulas don’t change while dragging, $ may be locking references.
Example:
=$A$1 + B2
This keeps A1 fixed.
If you want relative behavior:
=A1 + B2
Use $ only when needed.
Step 6: Remove Merged Cells
Autofill doesn’t work across merged cells.
Fix:
- Select range
- Format → Merge cells → Unmerge
Step 7: Check for Protected Ranges
If cells are protected, autofill won’t apply.
Fix:
- Data → Protect sheets and ranges
- Remove or edit protection
Step 8: Use ARRAYFORMULA Instead of Dragging
For automatic fill without manual drag:
=ARRAYFORMULA(A2:A * B2:B)
This fills the entire column dynamically.
Step 9: Use SEQUENCE for Number Series
Instead of dragging:
=SEQUENCE(10,1,1,1)
Generates:
- 10 rows
- Starting from 1
- Increment 1
Step 10: Fix Browser or UI Issues
If autofill doesn’t respond:
Fix:
- Refresh page:
Ctrl + Shift + R - Try Incognito mode
- Clear browser cache
Common Mistakes
- Using only one value (no pattern)
- Numbers stored as text
- Incorrect use of
$in formulas - Autofill blocked by merged cells
- Ignoring protected ranges
- Expecting complex pattern detection automatically
- Browser glitches affecting drag behavior
Pro Tips / Better Alternatives
Use ARRAYFORMULA for Scalable Models
=ARRAYFORMULA(IF(A2:A="", "", A2:A * 10))
No need to drag formulas.
Use SEQUENCE for Structured Data
=SEQUENCE(100)
Creates 1–100 instantly.
Combine SEQUENCE with Dates
=SEQUENCE(10,1,DATE(2024,1,1),1)
Generates date series.
Use Fill Down Shortcut
Instead of dragging:
Ctrl + D
Fills down selected range.
Pre-Clean Data
Use:
=TRIM()
=VALUE()
Ensures proper autofill behavior.
Bottom Line
If autofill isn’t working, fix in this order:
- Provide a clear pattern (at least 2 values)
- Ensure correct data type (number/date)
- Check formula references (
$) - Remove merged or protected cells
- Use ARRAYFORMULA or SEQUENCE if needed
Most issues come from pattern detection and data format problems.
Fix those, and autofill will work consistently.