Table of Contents
Google Sheets is a spreadsheet application that provides users with a simple and efficient way to organize and analyze data. One of its useful features is the ability to fill a series of cells with a specific pattern or sequence. This can be done by selecting the desired cells and using the “Fill” function, which can be found in the “Edit” menu or by right-clicking on the cells. This function allows users to quickly and accurately fill in a series of numbers, dates, or custom sequences, saving time and effort. Additionally, users can also use the “Auto Fill” feature, which automatically detects patterns in the data and fills in the remaining cells accordingly. Overall, the “Fill” function in Google Sheets is a valuable tool for efficiently populating a series of cells with a desired sequence.
Fill Series in Google Sheets (4 Examples)
Often you may want to fill in a series with values in Google Sheets. Fortunately this is easy to do using the simple drag and fill feature built into Google Sheets.
This tutorial explains how to fill a series in four different scenarios:
1. Fill a Series of Numbers
2. Fill a Series of Letters
3. Fill a Series of Days
4. Fill a Series of Months
Example 1: Fill a Series of Numbers
To fill a series of numbers in Google Sheets, simply enter the value of the first two numbers:
Then hover over the bottom right-hand corner of the cell until a tiny “+” appears. Then click and drag down to however many cells you’d like in the same column:
Google Sheets will automatically detect the pattern between the first two numbers (e.g. add one value) and simply repeat this pattern for as many values as you’d like.
Example 2: Fill a Series of Letters
To fill a series of letters in Google Sheets, type in the first letter in some cell and then use the following formula to increment the letter by one:
=CHAR(CODE(A2)+1)
Then hover over the bottom right-hand corner of the cell until a tiny “+” appears. Then click and drag down to however many cells you’d like in the same column:
A series of letters will automatically be filled in.
Example 3: Fill a Series of Days
To fill a series of days in Google Sheets, simply enter the date of the first day:
Then hover over the bottom right-hand corner of the cell until a tiny “+” appears. Then click and drag down to however many cells you’d like in the same column:
Example 4. Fill a Series of Months
To fill a series of months in Google Sheets, simply enter the name of the first month:
Then hover over the bottom right-hand corner of the cell until a tiny “+” appears. Then click and drag down to however many cells you’d like in the same column:
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). “How can I fill a series in Google Sheets?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-fill-a-series-in-google-sheets/
stats writer. "“How can I fill a series in Google Sheets?”." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-fill-a-series-in-google-sheets/.
stats writer. "“How can I fill a series in Google Sheets?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-fill-a-series-in-google-sheets/.
stats writer (2024) '“How can I fill a series in Google Sheets?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-fill-a-series-in-google-sheets/.
[1] stats writer, "“How can I fill a series in Google Sheets?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. “How can I fill a series in Google Sheets?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.