How to Use Autofill in Google Sheets

Learn how to autofill in Google Sheets with the fill handle, keyboard shortcuts, mobile controls, and formulas for numbers, dates, and lists.

Contents

Don't Miss the Good Stuff

Get tech news that matters delivered to your inbox.

To autofill in Google Sheets on a computer, enter two starting values in adjacent cells, select both cells, then drag the small blue box at the selection’s lower-right corner down or across. Sheets continues recognized number and date sequences, while other lists repeat. On a phone or tablet, select the starting values and destination cells, tap the selection, then tap Autofill.

Choose your method based on what you want the remaining cells to contain. Series autofill extends a pattern, fill shortcuts copy existing values or formulas, and Smart Fill completes transformations from examples.

The short version

  • Continue a series: Select at least two adjacent starting values and drag the blue fill handle down or across.
  • Copy downward: Select the source and destination cells, then press Ctrl + D on Windows or ChromeOS, or Command + D on Mac.
  • Fill on mobile: Select your starting values and destination cells, tap the selection, then tap Autofill.
  • Transform text: Enter source data and example results, then trigger Smart Fill to complete the pattern.

MethodWhat it doesWhere to use it
Blue fill handleExtends number and date sequences or repeats listsComputer
Keyboard series commandContinues a pattern through selected empty cellsComputer
Fill downCopies values or formulas below the sourceComputer
Fill rightCopies values or formulas to the rightComputer
Fill rangeFills a selected range with one shortcutComputer
Autofill commandExtends a series or repeats a list using touch controlsAndroid, iPhone, and iPad
Smart FillCompletes transformations from examplesComputer
SEQUENCEGenerates numbers from one formulaGoogle Sheets formulas
ARRAYFORMULAExpands calculations into neighboring cellsGoogle Sheets formulas
Automatic autofill previewInserts a suggested fill when you accept itMac with Command + Enter

Extend numbers and dates with the fill handle

Enter at least two values in neighboring cells in a column or row. For a simple number sequence, enter 1 in the first cell and 2 in the next, then select both cells. Drag the small blue box at the lower-right corner of the selection through the cells you want to fill.

To fill across a row, place the starting values side by side, select them, and drag to the right. For dates, enter two starting dates, select both cells, and drag the handle down or across. Sheets extends a recognized number or date pattern through the destination cells.

Other lists repeat instead of developing a new sequence. For example, selecting cells containing two text labels and dragging the handle repeats those labels through the filled range. Use this method when you need a repeating list.

If you need more space, you can insert multiple rows in Google Sheets for a vertical list or add columns in Google Sheets for a horizontal one. Then select your starting values again and drag through the added space.

Continue a series using the keyboard

To extend a pattern without dragging, enter at least two adjacent starting values and select them. Extend the selection to include the empty destination cells below or to the right, keeping the starting values inside the selected range.

Press Ctrl + Alt + Enter on Windows or ChromeOS, or Command + Option + Enter on Mac. This continues the series through the selection. Use this shortcut when you want to extend a number or date pattern.

Copy values and formulas down or across

Use Fill down to copy existing content into the cells below it. Select the source cell together with all the destination cells below, then press Ctrl + D on Windows or ChromeOS, or Command + D on Mac. The top cell supplies the content for the selected cells beneath it.

To use Fill right, select the source cell and the destination cells to its right. Press Ctrl + R on Windows or ChromeOS, or Command + R on Mac. You can also select an entire source row together with the rows below for filling down, or a source column together with columns to its right for filling right.

These shortcuts copy formulas as well as values. For example, you can multiply values in Google Sheets in the first result cell, then select that cell and the destination cells below it before filling down. If you want increasing numbers, use the series method instead of copying the starting content.

For a block of cells, select the range you want to fill, then press Ctrl + Enter on Windows or ChromeOS, or Command + Enter on Mac. Google calls this command Fill range.

Use Autofill on Android or iPhone

Open your spreadsheet in the Google Sheets app on Android, iPhone, or iPad. Enter at least two starting values in adjacent cells, then drag the selection corner to include both those values and the destination cells.

Tap the selected cells, then tap Autofill. On Android, tap More first if the command is hidden. On iPhone or iPad, tap More, represented by the right arrow, if you need to reveal Autofill.

Recognized number and date sequences continue through the selected cells, while other lists repeat. If you need the pattern to reach farther, include all the destination cells in your selection before choosing Autofill.

Complete text patterns with Smart Fill

Use Smart Fill when you want results derived from existing data, such as first names extracted from full names. Enter the source data and example results so Sheets has a transformation pattern to follow.

Press Ctrl + Shift + Y on Windows or Chromebook, or Command + Shift + Y on Mac. Click a completed cell to inspect the formula Smart Fill generated. Ordinary Smart Fill does not require the enhanced Gemini feature.

Fill cells with a single formula

Use SEQUENCE when you want a numeric sequence without dragging. Select an empty starting cell, enter the following formula, and press Enter. It generates the numbers 1 through 10 vertically.

=SEQUENCE(10,1,1,1)

The arguments specify the number of rows, number of columns, starting number, and increment, in that order. Change those arguments to adjust your sequence, and leave enough empty cells for the resulting array. To generate 1 through 10 horizontally, enter this formula and press Enter.

=SEQUENCE(1,10,1,1)

For calculations across several rows, ARRAYFORMULA can produce multiple results from one formula. Enter the following example in the first output cell and press Enter. It multiplies the corresponding values in the two specified ranges and expands the results into neighboring cells.

=ARRAYFORMULA(A2:A10*B2:B10)

This approach lets you populate a range without copying a separate formula into every output cell. Some functions that return arrays expand automatically without ARRAYFORMULA.

Fix missing suggestions or unexpected results

If ordinary autofill or Smart Fill suggestions are missing, open the Tools menu and turn the autocomplete setting back on. To turn suggestions off, return to the same setting and deselect it. This setting controls suggestions; you can also fill cells by manually dragging the handle.

On Mac, press Command + Enter to accept an automatic autofill preview when Sheets displays one. If no preview appears, select your starting values and use the fill handle or the keyboard series command.

If you get repeated content when you wanted increasing numbers, enter and select at least two adjacent starting values, then use series autofill. The down and right fill commands copy content, so choose those when duplication is your goal. For transformations such as extracting first names, enter example results and use Smart Fill.

Frequently Asked Questions

Can you autofill several number series at the same time?

Yes, the keyboard series command can fill multiple series together when each has the same number of starting cells. Select the starting values and destination cells, then press Ctrl + Alt + Enter on Windows or ChromeOS, or Command + Option + Enter on Mac.

Can you fill cells on Android with an external keyboard?

Yes, connect an external keyboard and select the source and destination cells. Press Ctrl + D for Fill down, Ctrl + R for Fill right, or Ctrl + Enter for Fill range. Some keyboard languages and layouts can affect shortcuts.

How do you copy formula results without copying the formulas?

Copy the source cells and select the destination within the same spreadsheet. Open Edit > Paste special > Paste values only to insert the results. Choose Paste formula only instead when you want the formulas.

Are formula suggestions the same as autofill?

Formula suggestions help you write a formula by suggesting functions and ranges; fill commands propagate a finished formula. To enable that assistance, open Tools > Suggestion controls and select Enable formula suggestions. Begin your formula with = and continue typing.

Does enhanced Smart Fill work with numbers and dates?

Enhanced Smart Fill predicts English text values and does not trigger on numeric or date columns. You need an eligible Google Workspace or Google AI plan, or Workspace Experiments access, and at least three example rows with two distinct output values. When a suggestion appears, hover over its icon to inspect the proposed range, then click the suggestion bubble to insert the predictions. To reject them, click the cancel icon on the expanded suggestion pill.

Share