In a previous video, I showed you how to create a sequence one through 10 and randomize it just by going up to data and randomized range and selecting this sequence . But what if we have a very long sequence that we don't want to have to drag through and get the entire sequence by hand? Should you sort of how to just highlight that, but let's create a new sequence equals sequence and let's make this 500 rows columns one start one and step one. So that's gonna be a list of one through. 500. We get to the bottom down here, 500. So how do we select that? We don't want to have to drag our course. That's gonna take a while, right? So I'm gonna show you a trick. I'm gonna select the one i'm gonna press shift command, and I'm gonna hit once on the down arrow.

Once I hit, once it goes all the way to the bottom, because that's the last cell that has data in it before it's a blank cell. Now I have one through 500 all highlighted. So I can do command C or right click copy. Now I can do right click paste, special values only, and that will replace this formula with just the values . I can also. I just press command and hit the down arrow to go to the bottom, and I'm going to delete 5 0 1 by on all of the rows below it by doing shift command down arrow. Now, right click delete rows and look at that. I only have 500 rows, so I can select this whole column by just

selecting the letter A up here. And now I can go to data randomized range . I can do that again and again and again. And now I have a random list, one through 500. It's a very long sequence . Isn't that cool? You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.