# Fill down dates, numbers and series in Google Sheets

Learn how the fill handle and series fill work in Google Sheets, so dates, incrementing numbers and text patterns continue correctly down a column.

Fill down in Google Sheets copies or extends a value from a starting cell into the cells below it. Dragging the small square at the corner of the selection, called the fill handle, gives you a menu that decides whether the values repeat or build a series. The choice you make in that menu controls dates, incrementing numbers and text patterns alike. 

- The fill handle is the small square at the bottom right corner of a selected cell or range.
- A drag of one cell suggests a series, while a drag of two cells repeats the step you set.
- The autofill options menu lets you switch between copy and series fill after the drag.
- Two seed values tell Sheets the step for numbers and dates without guessing.
- Text with numbers, such as item 1, extends into a numbered sequence when you choose the series option.
 

## What the fill handle does 

The fill handle in Google Sheets is the small square at the lower right corner of the selected cell or range. Dragging it down, up, left or right sends the content of the selection into neighboring cells. The result follows a rule that Sheets selects from the pattern of what you selected. 

A drag sends either a copy of the original value or a continuation of a pattern. Copy repeats the same entry in every target cell. Series fill increases or decreases the value by a step across the target cells. The fill handle options menu, which appears at the end of the drag, lets you change that rule. 

The fill handle works on a single cell, a row, a column or a block of cells. Google Sheets reads the first cells of the selection to decide what the pattern is. A selection that already shows a step, such as two or three numbers, gives the clearer signal. 

- Select the cell or range that holds the starting values.
- Point at the fill handle until the cursor changes to a cross.
- Drag the handle over the cells you want to fill.
- Open the fill handle options menu at the drop point.
- Choose copy, series fill or a date-based option.
 

## Fill down dates as a series 

Filling down dates in Google Sheets produces a date series when the drag is set to continue the pattern. Sheets recognizes a valid date entry and offers continuation by day, weekday, month or year in the options menu. The option you pick sets the step for every filled cell. 

A date series needs one seed value and a clear choice of step. Dragging a single date and keeping the series option moves one day at a time, which suits a daily log. Choosing the weekday option skips weekend dates and fills working days only, without any manual editing. 

Two dates in the starting selection set the step for you. If the first two cells are a week apart, the series continues a week apart, and the same logic holds for a month or a year. Dates entered as text do not continue, so confirm that Sheets reads the cells as dates before you drag. 
| Step wanted | Seed cells to select | Option to pick | 
| Every day | One date | Fill days | 
| Working days | One date | Fill weekdays | 
| Every week | Two dates a week apart | Series from the pattern | 
| Same date each month | Two dates a month apart | Series from the pattern |  

## Fill down numbers as a series 

Filling down numbers in Google Sheets extends into a series when the selected cells carry a step. One number dragged with the series option counts up by one, while two numbers set your own gap. The autofill sequence follows whatever step the seed cells show. 

Incrementing numbers need a clear starting point and a consistent difference. If the target cells repeat the same number, the drag ran as a copy; switch it in the options menu to a series and the values climb from the seed. Negative steps work the same way when the second seed is lower than the first. 

A drag on a formula behaves differently from a drag on a typed number. Relative cell references shift as the formula moves down, so a formula that adds one to the cell above builds a running count. Review the first two results of a formula fill before extending it across a long column. 

## Copy a value instead of continuing it 

Copy fill repeats one value in every target cell and suits identifiers, labels or a fixed tax rate. The copy option appears in the fill handle options menu after the drag, and it holds the original entry exactly as written. Copy fill leaves a text label untouched across a whole column. 

Copy is the safer choice when a value must not change between rows. A part number, a region name or a fixed fee should read the same in each cell, and a series there would break the meaning of the column. Switch the drag back to copy whenever the pattern is not wanted. 

Copying a formula instead of a value gives another result because relative references adjust with each row. Absolute references, marked with dollar signs, hold their cell during a copy fill. Decide which reference style the column needs before you drag the handle. 

- Copy fill for fixed labels and identifiers.
- Series fill for counts and dates.
- Relative references for row-by-row formulas.
- Absolute references for a value held in one cell.
 

## Mix text and numbers in a fill 

Text combined with a number, such as item 1 or week 2, can extend into a numbered pattern. Sheets reads the trailing number and raises it in each filled cell when the series option is active. Text without a number repeats, because Sheets has no step to follow. 

A leading zero in the number changes how the fill behaves, since Sheets may read the entry as text. Formatting the column as plain text keeps the zeros visible in a copied label. Decide whether the column is a label or a count before you drag it. 

Two starting entries such as item 1 and item 3 define a step of two for the text series. Mixing a word, a space and a number in a consistent layout is what lets the pattern work. Irregular entries, such as a stray symbol, stop the fill from continuing cleanly. 

## Use the fill handle options menu 

The fill handle options menu is the small panel that appears at the end of a drag and controls the result. It offers copy, series fill and date-specific choices depending on what the selection contains. Opening the menu after the drag is the reliable way to correct an unwanted copy. 

The menu adapts to the data type in the selection. A date gives day, weekday, month and year steps, while a number gives a plain series option. When the menu shows only copy, Sheets has not detected a pattern and treats the entry as a label. 

Choosing an option applies it to the filled cells immediately and leaves the seed cells unchanged. A second drag that starts from the same seed overrides the earlier result. Keep the seed row intact so the pattern stays easy to rebuild. 
| Menu choice | Result | 
| Copy | Same value in every cell | 
| Series | Step continues from the seed cells | 
| Fill weekdays | Dates skip weekend days | 
| Fill months | Dates advance one month per cell |  

## Fill vertically and horizontally 

The fill handle works sideways as well as down, so a row of dates can continue across columns. A sideways drag follows the same copy or series logic as a vertical one. The options menu appears at the far edge of the drag in either direction. 

A block selected in both directions extends as a grid when you drag the corner handle. Sheets repeats the whole block or continues each row and column according to the detected step. Confirm the corner cells of the result before extending a large grid. 

Keyboard routes exist for readers who prefer not to drag. Copying a cell, selecting the target range and pasting repeats the value, which is a plain copy fill. A dedicated fill command in the edit menu applies a series over a chosen range. 

## Fix a fill that goes wrong 

A fill that repeats a value instead of counting usually ran as a copy. Dragging again from the seed and choosing the series option in the menu corrects it. Check that the seed cells are real numbers or real dates, not text that looks like them. 

A series that jumps by the wrong step points to an unintended second seed value. Clearing the extra seed and starting from one cell gives a step of one, which you can then adjust. Consistency in the seed cells is what keeps the autofill sequence predictable. 

Undo the drag immediately if the result is wrong, then rebuild it with the correct option. Long columns are easier to verify by checking the first and last cells of the fill. Delete the filled range and start from a clean seed if the pattern has drifted. 

## Questions about filling series in Google Sheets 

### How do I fill down dates in Google Sheets without typing each one? 

Type the first date, select that cell and drag the fill handle down, then pick a date option in the fill handle options menu. Google Sheets reads the date and continues it by day, weekday, month or year. Two dates set your own interval and the series follows that gap. 

### How do I fill down numbers so they count up? 

Enter the starting number, drag the fill handle and choose the series option in the options menu. Sheets then increases the value by one per cell, or by the difference between two seed values. Switch the menu to copy to repeat the same number instead. 

### Why does my Google Sheets fill down repeat the same value? 

The drag ran as a copy, which is what Sheets does when it finds no pattern in the selection. Drag again from the seed and pick series in the fill handle options menu. Text entries with no number also repeat, because Sheets has no step to follow. 

### Can I build a date series that skips weekends? 

Yes, a date fill offers a weekday option that omits Saturday and Sunday. Select one date, drag the handle and choose the weekday fill in the options menu. The filled cells then advance only across working days. 

### Do two starting cells change the fill series? 

Two seed cells set the step for the series, so the fill continues at that interval. Seeds a week apart produce a weekly date series, and seeds that differ by two produce a step of two. Select the seed cells together before you drag the handle. 

### How do I fix a fill that went in the wrong direction? 

Undo the drag right away and rebuild it from the correct seed cells. Dragging downward extends a column, while dragging sideways extends a row. Keep the original seed row intact so the pattern is easy to restore.
