How To Auto-Fill Series in Google Sheets [Guide 2023]

How to fill series in google sheets 1

Google Sheets is famous for its automation features. For example, suppose you want to quickly get a series of 100 consecutive numbers. While you can do this manually, that’s a waste of time. Google Sheets is providing a faster solution. You can automatically create a series or list in just a few seconds using the GoogleSheets autofill tool. Google Sheets can autofill numbers based on the previous numbers not only numbers you can also fill series of dates, days, months, etc.

Google Sheets’ auto-fill tool also copies the formula over the cells as well. Which will get rid of writing, again and again, the same formula. Here is a complete guide below on how to fill series in Google Sheets.

Importance of using Fill Series in Google Sheets

Google Sheets autofill features are the most helpful feature for those professionals, ls especially those who are dealing with a large number of data sets. Manually writing the same text or text in series in all cells can affect the cost of time, although the fill series function of GoogleSheets can work very efficiently and can save a lot of time that’s why you must know how to fill series in Google Sheets.

See also  How to Use Macros in Google Sheets [Complete Guide]

How to Fill Series in Google Sheets?

There is nothing to do nor to press any key even to use the autofill function of Google Sheets. Just by clicking you need to drag your mouse over the cells GoogleSheets will automatically fill the series. There are many scenarios where fill series can be helpful, let’s see all of them one by one in the following steps.

Step 1

Before using the fill series function the GoogleSheets, you must confirm that “Autocomplete” all functions are enabled or not otherwise autofill will not work. To enable all, Autocomplete options to go into the “Tools” tab of the menu bar of the GoogleSheets then expand the “Autocomplete” option for further options.

How to fill series in google sheets 1

Step 2

There is several autofill or autocomplete options that you will have to check to enable them as shown below in the picture.

How to fill series in google sheets 2

Step 3

Now let me show you how does autofill feature of GoogleSheets works. As you can see in the following picture there is written “1” in the first cell and if you want to fill it entire table you don’t need to write manually in every cell just follow the further steps to autofill the series.

How to fill series in google sheets 3

Step 4

As you can see the blue selection around the cell and there is a square point on this selection, place your cursor near this blue point and drag it downwards or anywhere where you want to fill it automatically.

How to fill series in google sheets 4

Step 5

As you can see from the results, this is how the autofill feature of Google Sheets works. You have got the entire column in just one click.

How to fill series in google sheets 5

Step 6

In the above example all cells were filled with the same number but if you want to fill it with counting or serial numbers then just hold the Ctrl button while dragging and this will autofill the series in the results as shown below.

How to fill series in google sheets 6

Step 7

This autofill series not only works on counting or serial numbers but also you can write the day’s name with the autofill. As here I have written here first day’s name is “Monday“.

How to fill series in google sheets 7

Step 8

Now you do not need to write other weekdays manually just perform the same above trick, and you will get all other days automatically by the autofill function of Google Sheets.

How to fill series in google sheets 8

Step 9

Similarly for dates, you can also use the autofill series.

How to fill series in google sheets 9

Step 10

The autofill series works in many cases even this feature of GoogleSheets copies the functionality of formulas on other cells by dragging but in some cases, it doesn’t work directly.

How to fill series in google sheets 10

For example, writing alphabets by autofill will give you results in a series even by pressing the Ctrl button. As shown in the picture.

Step 11

To get the alphabets in series by autofill you will need to write a formula first then you can use autofill series to get the English alphabet.

How to fill series in google sheets 11

Formula: =Char(code(cell address)+1)

First, write the first alphabet A in the first cell then to get the second alphabet, we will apply the above formula as shown below in the picture.

Note: Cell address will be provided the cell address of the alphabet “A“.

Step 12

As you can see from the results of the above formula, We got our second alphabet “B“.

How to fill series in google sheets 12

Step 13

As we know autofill also copied the formula so here, we will drag the alphabet B over the other cells which will give all the alphabets continuously as the resultant below.

How to fill series in google sheets 13

In this way, you can also get the English alphabet in series with the help of autofill.

See also  How to Insert Calendar in Google Sheets [Free Templates]

Frequently Asked Questions

Is there any shortcut key to fill series in Google Sheets?

Yes, there is a shortcut key of autofill which is Ctrl + Enter. But before pressing the shortcut key to autofill you will have to select the cells where you want to fill the series then you can press Ctrl + Enter to get the autofill in Google Sheets. There are two more shortcut keys in GoogleSheets to autofill,

  • Ctrl + D: To autofill downward or in column
  • Ctrl + R: To autofill, the right side means in a row.

But this shortcut key doesn’t autofill in the entire column row at any formatted table. It will just fill the next cell. If you want to fill in a series with more than one cell, then first select the cells and then use the shortcut keys.

How can we the Auto-fill feature to fill in dates in a series?

It’s pretty simple, to fill in a series of dates in Google Sheets, enter the first date in the series, and then select the cell. Next, click and drag the fill handle to the last cell in the series. The Auto-fill feature will automatically fill in the series with consecutive dates.

How to fill series in google sheets 14

How to use the Auto-fill feature to fill a series of numbers?

As shown in the above examples, to fill a series of numbers in Google Sheets, enter the first number in the series and then select the cell. Now, click and drag the fill handle just like you do it for dates to the last cell in the series. The Auto-fill feature will automatically fill in the series with consecutive numbers.

Can I use the Auto-fill feature to fill a series of non-contiguous numbers?

Yes, you can use the Auto-fill feature to fill a series of non-contiguous numbers but you will need to provide more than one input to Google Sheets. For example, if you want a series that starts from 1 and skips one number and then 3 then another skip, then 5, and so on. To autofill this type of non-contiguous number, you can provide the initial values to Google Sheets, if you give 1 and 3 and then drag the same way, you will get the series of all the odd numbers starting from 1 and ending where you will stop your mouse.

How to fill series in google sheets 15

See also  How to Use Google Sheets Conditional Formatting Multiple Columns

Conclusion

Today we learned how to fill series in Google Sheets. In today’s busy life, everyone wants to finish his work in a jiffy. To do so we need to learn such shortcut ways to enter the data to make the workflow more efficient. Hope the above article on how to fill the series in GoogleSheets will be helpful in it. Thank you and keep learning with Office Demy.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

We will be happy to hear your thoughts

Leave a reply

OfficeDemy.com
Logo
Enable registration in settings - general