Nothing more comfortable, practical and that will help us save time than autofill sequential data in Google Sheets. Many of us fill in the cells of a Google Sheets spreadsheet manually, but we can do it automatically when it is sequential data and getting it is much easier than you imagine.

Automatically fill sequential data in Google Sheets

The guide that we will see a little further down is very simple and serves to give us an idea of ​​​​the possibilities. We can do this with pretty much any kind of sequential data we have. Therefore, it is not necessary to limit yourself to the examples set forth below.

With sequential numbers

We start with the guide.

To automatically complete sequential numbers, such as 1 to 10, we will have to click on a cell in our spreadsheet and type 1. In the cell below we will type 2.

We drag cells.

We will select both cells. Then we will click on the small blue box that is in the lower right corner of the second cell and drag it down.

Sequential Data Result Sheets

The sheets will be filled with the sequential numbers. It is also possible to use this method for negative numbers. The only difference is that we will have to write -1 instead of 1 and that’s it.

Fill sequential odd numbers

Odd numbers.

In order to automatically fill the cells with odd numbers (leaving aside any even numbers) we will have to click on the first cell and put 1. Then we click on the second cell and put 3.

We choose the second cell.

We do the same as in the previous example. We select both cells and click on the box in the lower right corner of the second cell, we will drag it down.

Sheets sequential data is automatically populated.

The cells will be filled with all the odd numbers, as we will see next.

YOU CAN ALSO READ:   How to combine multiple CSV files into one Excel workbook

Fill sequential even numbers

Select second cell.

Another thing we can do is automatically fill in even numbers like 2, 4, 6, 8, etc. For this we are going to write a 2 in the first cell and a 4 in the second.

Drag

Then from the bottom right corner of the second cell, we’re going to click and drag down.

Result.

Now we will only see even numbers in the cells.

sequential months

Select cell.

Another interesting thing we can do is fill the cells with the months of the year automatically. The only thing we will have to do is write the name in the first cell and then everything will be done automatically.

Select month.

We touch the first cell and we will write “January”.

So we can automatically fill sequential month data in Google Sheets

Then we click on the lower right corner and drag down. In this way, all the cells will be filled with the names of the months.

Fill Formulas

Select formula.

With the automatic fill function we will not have to write a formula in each cell. Instead, we can drag the cell containing the formula to the cells where we want it and the formula will be copied.

Drag

Even the cell reference will be changed so that we have the correct data in the cells of the formula. To do this we are going to have to go right to the first record of the spreadsheet, write the formula and press Enter.

Automatically fill sequential data Sheets

From the bottom right corner of the cell where we entered the formula, we drag down until we cover all the records.

This will copy the formula to all the cells that we drag. Then we will see the corresponding results in the formula cells.

Write A Comment