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,
autofill numbers google spreadsheet
Step 2: Select both the cells using arrow keys or mouse.
autofill numbers google spreadsheet1
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.
autofill numbers google spreadsheet2
As we have given the difference 1 the following cell increment the numbers by 1 and displays the series.
autofill numbers google spreadsheet3
Like this, you can add any number with the required difference and increment the numbers to autofill the cells.


Related Topics

Google Docs Spreadsheet Tutorial