Site icon WPDig.com

Automatically fill sequential data in Sheets

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

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 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.

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

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 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.

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

Fill sequential even numbers

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.

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

Now we will only see even numbers in the cells.

sequential months

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.

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

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

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.

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.

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.

Exit mobile version