Drag and Increment Numbers in Google Sheets

How to drag and increment numbers in Google Docs Spreadsheets?

Explanation

Numbers can be filled or incremented in the continuous cells with the given difference using the below steps,
Step 1: Enter the numbers one below the other. For example, enter 1 and 2 in the below cell,

Step 2: Select both the cells using arrow keys or mouse.

Step 3: Click the first cell and move the mouse to the right bottom of the cell. Cursor changes to plus and drag the plus symbol to the extend you need to add the series.

As we have given the difference 1 the following cell increment the numbers by 1 and displays the series.

Like this, you can add any number with the required difference and increment the numbers to autofill the cells.

Related Topics