Skip to main content

June 29th, 2026

How to Autofill in Google Sheets: Dates, Numbers & Formulas

By Drew Hahn · 19 min read

XLinkedIn
Learn about the 10 best AI HR Tools to use in 2025 - like Julius AI

Learning how to autofill in Google Sheets saves real time on repetitive data entry: numbers, dates, formulas, or custom sequences. I've pulled together every method that works, from basic fill handle tricks to keyboard shortcuts and custom lists.

What is autofill in Google Sheets?

Autofill in Google Sheets is a built-in feature that detects patterns in your data and automatically extends them across rows or columns. You give it a starting value or sequence, and it fills in the rest without manual entry.

You can use it for numbers, dates, days of the week, months, text patterns like "Item 1, Item 2," and formulas. It works in any direction, down, up, left, or right, depending on how you drag the fill handle.

How to autofill in Google Sheets using the fill handle: 3 methods

The fill handle is the small blue dot that appears in the bottom-right corner of any selected cell in Google Sheets. It's the starting point for most autofill tasks, and there are 3 ways to use it depending on how much data you're working with. 

Here's how each one works: 

  1. Drag to fill: Click a cell that contains your starting value, hover over the fill handle until your cursor changes to a crosshair or plus sign (+), then drag in any direction. Google Sheets detects the pattern and fills the selected range. This is the method I use most for smaller datasets where I want visual control over how far the fill extends.

  2. Keyboard shortcuts: Select the cell with your starting value, highlight the range you want to fill, then press Ctrl+D (Cmd+D on Mac) to fill down, or Ctrl+R (Cmd+R on Mac) to fill right. I find this method the quickest for filling across rows, since it skips the mouse entirely.

  3. Double-click to fill down: Click the cell you want to fill from, then double-click the fill handle. Google Sheets fills down automatically, matching the length of the data in the adjacent column. This only works if the neighboring column has data in it, so it's most useful mid-spreadsheet rather than in an isolated column.

How to autofill a series in Google Sheets

Autofill gets more useful once you move beyond copying a single value. Google Sheets can recognize a wide range of patterns and extend them automatically, as long as you give it enough context to work from.

Here's how it handles each data type:

Numbers and custom sequences

Google Sheets can extend a number sequence automatically once it understands the pattern you're working with. Here's how to set it up:

  1. Enter your starting values: Type your first 2 values into adjacent cells to establish the pattern. For a simple count (1, 2, 3), enter 1 in the first cell and 2 in the second. For a custom increment like 5, 10, 15, enter 5 and 10. Google Sheets uses the difference between the 2 values to continue the sequence.

  2. Select your starting cells: Click and drag to select both cells before moving to the next step.

  1. Drag the fill handle: Hover over the bottom-right corner of your selection until the cursor becomes a crosshair, then drag in the direction you want to fill. I use this for invoice numbering and row IDs where typing each value manually would introduce errors. 

💡Tip: If you only have a single starting value, hold Ctrl on Windows (Option on Mac) while dragging from a number cell to force an increment by 1.

Dates

Google Sheets increments dates automatically when you drag the fill handle, defaulting to one day at a time. Here's how to control it:

  1. Enter your starting date: Type a date into a cell. If you want a specific interval like every 7 days, enter the first 2 dates of your sequence.

    1. Select your starting cells: Select both cells if you entered 2 dates, or just the one cell for a daily increment.

    2. Drag the fill handle: Drag in the direction you want to fill. Google Sheets continues the interval you set, whether that's daily, weekly, or monthly.

Days of the week and months

Google Sheets recognizes day and month names out of the box, including abbreviations. Here's how to use them:

  1. Type any day or month name: Enter a value like "Monday" or "Jan" into a cell. Google Sheets recognizes both full names and shortened versions.

2. Drag the fill handle: Drag in the direction you want to fill. Sheets continues the sequence in order and loops back to the beginning once it reaches the end. I find this useful for building repeating weekly schedules or monthly report headers without manual typing.

Text patterns

If your text ends in a number, Google Sheets can continue the sequence automatically. Here's how it works:

  1. Enter your starting value: Type a value like "Task 1" or "Region 1" into a cell. The number needs to appear at the end of the text for Sheets to detect the pattern.

2. Drag the fill handle: Drag in the direction you want to fill. Google Sheets increments the number at the end of each entry while keeping the text prefix the same. This works well for labeling rows in trackers, reports, and any numbered list where typing each entry manually would slow you down.

How to autofill formulas in Google Sheets

Autofilling formulas works differently from autofilling values. Google Sheets doesn't just copy the formula, it adjusts the cell references as it fills. This can either save you a lot of time or cause unexpected results depending on how your formula is set up. 

Here's how each approach works:

Relative vs. absolute references ($ signs)

By default, Google Sheets uses relative references, meaning cell references shift as the formula fills down or across. This is useful most of the time, but breaks when you need a formula to always point to the same cell. 

Here's how to control it:

  1. Identify which references need to stay fixed: If your formula adds each row to a tax rate sitting in cell B2, that B2 reference needs to stay put no matter how far you fill down.

2. Add dollar signs to lock the reference: Type a $ before the column letter, the row number, or both, directly inside the formula itself. For example, if your formula reads =A2*B2 and you want B2 to stay fixed, change it to =A2*$B$2 in cell C2. $B$2 locks the entire cell, B$2 locks the row only, and $B2 locks the column only.
3. Drag the fill handle to fill the formula: Once your references are set correctly, drag down from C2 to C5. The A column reference shifts with each row while the locked $B$2 reference stays fixed, pulling the same tax rate into every calculation.

ARRAYFORMULA for dynamic data

ARRAYFORMULA lets a single formula apply to an entire column automatically, so you don't need to fill down at all. When new rows are added, the formula extends to cover them without any manual input.

Here's how to use it:

  1. Write your formula as normal: Start with the calculation you want to apply, for example =A2*B2.

2. Wrap it in ARRAYFORMULA: Change it to =ARRAYFORMULA(A2:A*B2:B), replacing individual cell references with column ranges. This tells Google Sheets to apply the formula across the entire range.
3. Enter it in the first cell of your column: Press Enter and the formula covers every row with data automatically. I use this for calculated columns in reporting sheets where new data gets added regularly, since it removes the need to remember to fill down each time.

SEQUENCE function

SEQUENCE generates a list of numbers in a set pattern without dragging anything. It's useful when you need a clean numbered column or want to build a structured grid of values from a single formula. 

Here's how to use the SEQUENCE function:

  1. Choose your dimensions by deciding how many rows, columns, start value, and step size you need. For a simple numbered list of 10 rows starting at 1 and incrementing by 1, the formula is =SEQUENCE(10,1,1,1).

  2. Enter the formula in the first cell of your range: Type =SEQUENCE(10,1,1,1) into any cell and press Enter. Google Sheets automatically fills the sequence downward from that cell, no dragging required.

3. Adjust the step size for custom intervals: To generate a list that increments by 5, change the last argument to 5, so =SEQUENCE(10,1,1,5) gives you 1, 6, 11, 16, and so on. I find this cleaner than dragging when I need a precise sequence with a specific starting point and interval.

How to use Smart Fill in Google Sheets

Smart Fill is a more advanced version of autofill that detects relationships between columns rather than just extending a sequence. It's useful for tasks like pulling first names out of a full name column, or matching values across 2 columns based on a pattern it recognizes. 

Before you start, make sure Smart Fill is turned on by going to Tools, then Suggestion controls, and checking that Enable autocomplete is selected.

Here's how to use Smart Fill in Google Sheets:

  1. Set up your data: Create a column of full names in column A with a "Full Name" header in A1. In column B, add a "First Name" header in B1. Your source column and output column need to be next to each other with no blank column in between.

2. Enter a few values manually: Type the first 2 or 3 first names in B2 and B3 so Google Sheets has enough context to detect the pattern.
3. Press Enter: Google Sheets analyzes your entries and displays a gray preview of the suggested values in the cells below. If no suggestion appears, enter one more value manually to give Sheets more context.

How to autofill in Google Sheets on mobile

Autofilling on mobile takes a few more steps than on desktop, but the process works on both Android and iOS. Here's how to do it:

  1. Enter your starting values: Tap a cell and type your first value, then enter your second value in the cell below to give Google Sheets a pattern to work from.

  2. Select your full range: Tap the first cell, then drag the blue selection handle down to cover both your starting values and all the cells you want to fill.

  3. Tap the selected area: A context menu appears with options like Cut, Copy, and Paste. Tap Autofill and Google Sheets extends the pattern across your selected range automatically.

💡Note: Smart Fill is not available in the Google Sheets mobile app. For anything beyond basic series fills, you'll need to switch to desktop.

Google Sheets autofill not working? Here's how to fix it

Autofill in Google Sheets is reliable most of the time, but a few common issues can trip you up. Here's what to check if something isn't working as expected:

You're getting repeated values instead of a sequence

This happens when you drag the fill handle from a single cell. Google Sheets copies the value instead of incrementing it. To fix this, enter your first 2 values to establish the pattern before dragging, or hold Ctrl on Windows (Option on Mac) while dragging from a single cell to force an increment by 1. This is the mistake I run into most often when setting up a new sheet in a hurry.

Double-clicking the fill handle does nothing

The double-click method only works when there's data in an adjacent column. Google Sheets uses that neighboring column to determine how far to fill down. If the column next to yours is empty, double-clicking won't do anything. Use drag or the keyboard shortcut instead.

Your formula results look wrong after filling down

This usually means your cell references are shifting when they shouldn't be. Check your formula for any references that need to stay fixed and add $ signs to lock them in place. I'd recommend checking the first 2 or 3 filled cells before assuming the whole column is correct.

Smart Fill suggestions aren't appearing

First check that Smart Fill is turned on by going to Tools, then Suggestion controls, and confirming Enable autocomplete is selected. If it's already on, try entering one more example value manually to give Google Sheets more context to detect the pattern.

The fill handle isn't showing up at all

This can happen if the cell or range is locked or protected. Check if the sheet has any protected ranges set up under Data, then Protect sheets and ranges. You may need to adjust the permissions before autofill will work.

Want to do more with your Google Sheets data? Try Julius.

Learning how to autofill in Google Sheets helps you build and organize datasets faster, but once your data is ready, the next step is actually analyzing it. Julius is an AI-powered data analysis platform that does that part: ask a question in plain English, and it searches for public data or connects to your existing sources, then returns the charts, insights, and reports you'd otherwise build by hand. 

Here's how Julius helps:

  • Data search: Instead of hunting down a dataset to paste into your sheet, Julius pulls public data from the web or structured financials for 17,000+ companies through its Financial Datasets integration, so you start from a question instead of a blank tab.

  • Direct connections: Upload the spreadsheet you've been building, or connect straight to PostgreSQL, Snowflake, BigQuery, Google Ads, and other tools. Your analysis runs on live data, so you're not re-pasting numbers into a sheet every week.

  • Repeatable Notebooks: Save an analysis as a notebook and run it again with fresh data whenever you need. You can also schedule notebooks to send updated results to email or Slack.

  • Built-in data visualization: Generate line charts, bar comparisons, and KPI summaries on the spot, so you don't have to jump to another tool to visualize what your data is showing.

  • Smarter over time: Julius's Learning Sub Agent picks up how your data fits together as you use it, learning table relationships and column meanings so its answers get more accurate the longer you work with it.

Ready to see what your data can tell you? Try Julius for free today.

Frequently asked questions

What is the difference between autofill and Smart Fill in Google Sheets?

Autofill extends a pattern you've already started, like a number sequence, dates, or a formula, while Smart Fill detects relationships between columns and fills values based on those relationships. For example, autofill can continue 1, 2, 3 down a column, while Smart Fill can extract first names from a full name column after you provide a few example entries.

Can you autofill from another sheet in Google Sheets?

Yes, you can autofill from another sheet by referencing it directly in your formula using the format SheetName!CellReference, for example =Sheet2!A2. Drag the fill handle down and the references update automatically across each row.

How do I autofill dates in Google Sheets?

You can autofill dates by entering your first 2 dates in adjacent cells to establish the interval, selecting both, then dragging the fill handle in the direction you want to fill. For a daily sequence, enter 2 consecutive dates. For weekly or monthly intervals, enter 2 dates that show the gap you want and Google Sheets continues that pattern automatically.

— Your AI for Analyzing Data & Files

Turn hours of wrestling with data into minutes on Julius.

Geometric background for CTA section