What is autofill in Google Sheets?
Autofill copies a cell or selection downward or sideways using the small blue square fill handle. Sheets detects simple series like 1,2,3 or Mon,Tue,Wed and continues the pattern. Formulas copy with relative references adjusting per row unless you locked absolute refs. Autofill is the fastest way to propagate a working formula across hundreds of rows when ARRAYFORMULA is not needed.
When to use it
Use autofill after you nail the formula in row 2: running totals, month labels, incremental ids, and formatting you want repeated down a column.
When to skip it
Skip autofill when the column should stay dynamic from one spill formula, or when pattern detection guesses wrong on irregular text series.
How it works
-
1
Enter value or formula in starting cell, select it, drag the fill handle down the column.
-
2
Double-click fill handle when adjacent column has data to auto-fill to last row in some cases.
-
3
Hold modifier keys while drag if your OS supports alternate fill behavior per Google help docs.
-
4
For dates, type two sample dates so Sheets infers step size before dragging.
-
5
Copy formats only with paste special after autofill if formulas should not duplicate styles.
-
6
Verify last rows after autofill on tables that grow monthly; extend fill when new data arrives.
Examples in Google Sheets
Month series
Type Jan and Feb, select both, drag fill handle to Dec for header row across columns.
Formula down column
Row 2 VLOOKUP works; double-click fill handle fills to last row beside populated id column.
Weekday pattern
Monday and Tuesday cells dragged produce full week labels for shift schedule template.
Better Sheets resources
Common mistakes
-
Autofill guessing linear series on codes like SKU-9, SKU-10 incorrectly.
-
Dragging formulas over spill range blocking dynamic array output.
-
Forgetting absolute locks so rate cell reference walks away row by row.
-
Autofill formatting into cells that should stay plain text IDs.
-
Assuming autofill updates when source table shrinks; orphan formulas remain below.
Frequently asked questions
- Autofill vs ARRAYFORMULA?
- Autofill copies separate formulas per row. ARRAYFORMULA or spill uses one formula for many rows.
- Autofill not working?
- Select source cell with fill handle visible. Ensure not in view-only mode without edit rights.
- Fill without dragging?
- Copy cell, select target range, paste. Or use ARRAYFORMULA for formula columns.
- Autofill custom list?
- Sheets infers from first cells typed. No Excel-style custom lists unless pattern is clear.
- Autofill dates skipping weekends?
- Not automatic. Use WORKDAY or SEQUENCE with step logic in formula instead.
- Autofill on mobile?
- Awkward. Use desktop for long drags or use ARRAYFORMULA.
- Smart Fill vs autofill?
- Smart Fill infers transforms from examples. Autofill extends simple series and copies formulas.
- Undo autofill?
- Ctrl+Z immediately after fill. Version history if saved long after.
Related Tutorials
Watch how Autofill works
Move Cells to New Row with Formula
Automatically Copy Spreadsheet Tab to New File with Values Only, No Formulas
Add Autocomplete with Custom Function
Replace 1,000 Formulas Instantly
Related blog posts
Guides that explain Autofill in more depth.
How to create a formula for every row in a column in a Google Spreadsheet?
3 possible ways to create a formula for every row in a column in a Google Spreadsheet. And two bonus ways to make it look nicer. - Auto fill - Double Click - ArrayFormula
Read post →Protect Your Formulas from Accidental Deletion in Google Sheets
Ever spent hours crafting the perfect formula in Google Sheets, only to accidentally delete it? It's a frustrating experience that can derail your productivity. Fear not! In this guide, we'll unveil some clever tricks to safeguard your hard work.
Read post →Google Sheets AI Formula
Does Google Sheets have an AI Formula? No but you can add one. Simple use Apps Script to add an AI formula to your sheets. You can use your own AI from Open AI and this comes out to be much cheaper than even $20 a month for ChatGPT at times. Depends on your use of AI. I just updated Better Sheets' AI apps script to use Open AI Omni. Get the full script here. Can I use ChatGPT in Google Sheets? No but you can create ChatGPT in Google Sheets. Let me show you! But I need help with Google...
Read post →Related terms
Smart fill
Smart Fill watches columns next to your edit and suggests completing a pattern when it recognizes one. Type a couple examples in a new column beside source data and Sheets may offer to fill the rest with names, emails split from full text, or formatted dates. It is Google's answer to flash fill for quick cleanup without formulas.
Read guide →ARRAYFORMULA
ARRAYFORMULA tells Google Sheets to treat a formula as an array operation so one expression fills many cells at once. It is common with IF, VLOOKUP, and math on full columns before dynamic arrays made many patterns automatic. It still matters for legacy sheets and explicit control.
Read guide →Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text sits in quotes, and operators like + and & combine values. Sheets recalculates when inputs change, so syntax errors show as #NAME? or #ERROR! in the cell.
Read guide →Absolute reference ($)
Absolute references lock row, column, or both with dollar signs so a formula keeps pointing at the same cell when you copy it. $A$1 locks both axes. A$1 locks the row. $A1 locks the column. Mixed locks are how tax rates stay in one settings cell while a formula fills down a thousand rows.
Read guide →Done reading about Autofill?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.