December 4, 2020

How to autofill numbers and fill series in Google sheet

How to autofill numbers in Google sheet

In this lesson we will learn about how to autofill numbers in Google sheet with a simple example as follows. We have a table containing different phases to build an office along with the start date and duration of each phase.

Now we need to add serial numbers in the first column.

  • To do that first add the first two numbers of your serial numbers in the first two cells of the column. Here we have added number 1 & 2  in the first two cells of the first column.

  • Then select the first two cells and a small blue box in the lower right corner will be appeared.
  • Drag the blue box up to any number of cells down in the column. You can see the numbers have been autofilled serially as follows.

  • This process can be applied to autofill the serial numbers in a row as well. You just need to add the first two numbers in the first two cells of the row and then drag the blue box up to any number of cells right in the row as follows.

How to fill series in Google Sheet

In this lesson we will learn about how to fill series in Google sheet. The Series can be of numbers, months, days ,years or dates.

Let’s first create a series of Months. To do that first add the first two months in the first two cells and then select the first two cells and drag the small blue box in the lower right corner up to any number of cells down in the column(or row if you are creating the series in a row) as follows.

As you can see above, once the months end up, it will start from the beginning.

Now we will create the month series with the first three letters of the month and in the interval of 3 months. To do that the entire process demonstrated above will be the same only the first two months we have entered in a gap of 3 months as follows.

In the next example we have created a series of years(or it can be considered as a series of numbers) in a difference of two, starting from 2012 in the same way as mentioned above.

In the next example we have created a series of dates with a difference of five, starting from a random date in the same way as mentioned above.

In the next example we have created a series of days in a difference of two, starting from Tuesday in the same way as mentioned above.

Leave a Reply

Your email address will not be published. Required fields are marked *