News‎ > ‎

Fill Series in Google Sheets

posted Nov 14, 2013, 6:47 PM by Unknown user   [ updated Nov 14, 2013, 6:47 PM ]
Have you ever wondered how to fill a series in a Google Sheet? I know I have and today I learned how.

OK, suppose you have a Google Sheet that looks like this:

Now, you want to have each row in the Student Last Name column be populated with the word "Account" followed a 2 digit number that is in series: 01, 02, 03, etc. Notice the small blue square in the lower right corner of the selected cell. This is the "fill" box. If you click on this fill box and drag down, it will simply copy the contents of the selected cell to each of the boxes you drag over. Close, but not want we want.

But if we want to have each row be unique, we must do the following:

1. Type 2 examples of the desired format (see image left).

2. Select both of these examples BEFORE dragging as in the introduction.

What does this do? It demonstrates to Google Sheets the pattern to replicate as we drag down.

3. Now click on the small blue box in the bottom right corner of the selection and drag down.

When you release your mouse button, Google Sheets will automagically fill in each row, incrementing the entries as indicated by the 2 examples you highlighted.

BOOM! You can now auto-fill a series in Google Sheets!