How to Add a Series to a Google Sheet

Name: How to Add a Series to a Google Sheet
Uploaded: 2026-07-10T05:00:23-07:00
Description: Learn how to efficiently add a series of numbers to your Google Sheets using the SEQUENCE function and simple drag techniques. This video provides step-by-step instructions to automate ID generation for your data.

Learn how to efficiently add a series of numbers to your Google Sheets using the SEQUENCE function and simple drag techniques. This video provides step-by-step instructions to automate ID generation for your data.

So, you want to add a series to a Google sheet. We got our employee names here and we want to add IDs one through however many people there are. If we have our names already and we have some data inside of our cells in column C and we want to put our numbers in column B, there's a really easy way to do this. You can just do one and two and then select one and two. There is a little blue dot in the bottom right corner. Once you see a crosshairs, you can double click that and magically it will fill in for however many names you have. However, if you add a name here, add a name, it doesn't continue. So, I'm going to show you how that could be. Well, we could do equals sequence and sequence is

going to be some numbers of rows. We're going to use count all 3 col C and it's going to count however many things are inside of the C column from C3 all the way to C. And if you want to see what that would look like, we can put in this cell here and that's 19. And then when I go down one more name and I see now it's 20, right? So do sequence count a C3 col C and that's our rows. Our column is only one. Our start is only one. Our step is only one. And we might get a reference error if there's already ids here. Let's delete those. And now magically we have this formula

here in B3 that's magically filling out this. And if we add one more more name, magically that series is just continuing. That sequence is just continuing one at a time. And there's no data here. If you're trying to get all this data and you don't want that, you can command C, shift commandV to paste values if you don't want that formula there anymore. But I think this really fun way to add a series to a Google sheet. You're watching Better Sheets here on YouTube. You have two options here for your next video. Before you go, comment down below if you have any question whatsoever, and I'll make future videos from those questions. But for right here, right now, one of these videos could be your

next Google Sheet.