So you wanna find a tab name, and you might have dozens of tabs or hundreds of tabs. And there's a few ways to find these tab names. So here we have a bunch of students. We have their names here, and we can click on all sheets. These hamburger menu, three lines over on the bottom left can click here and we can scroll through this. But this is a very time consuming and we have to look for each name. Maybe they're not in a particular order or anything. It's hard to find. Also, we can do this by holding down option and up or down. If we go down and we can flip through each and every tab. If you see on the bottom, my tabs are changing even though they have all blank tabs, right? So that's not very helpful, right?

Obviously command F finding in the sheet cannot. Use that to find the tab name and also can't use find and replace to even find a tab name. However, let's use a little app script to get a list of all of our sheets and then we can search through that to find it. So let's go to Extensions app script . So I've already written this function , it's called Function All Sheets or Get All Sheets. We're looking at the All Sheets tab, and we're going to look at every single tab in the sheet. Get the URL and we're going to get the ID as well to get the URL. And we're just gonna push a list right here. So if you want this script is down below in the description.

Get it today. I'm going to do all, get all sheets, run it. You may have to authorize at this moment, if we go back to our sheet, we see an alert all sheets tab updated, but you see there's nothing here yet. So let's click okay and in a moment everything's there. So now this is every single tab in my spreadsheet file. Now I can do command F. I want to find Owen Rivers. There he is. And here's a link directly to Owen Rivers. Awesome. This is really cool, right? So now we can search tab names and we can also update this fairly easily, right by just going to Extensions app script , going over here and clicking run. Very cool. If you want to do more with your app scripts, check out the course.

Spreadsheet Automation 1 0 1 on better sheets. It's fantastic to get you into reading all of these and being able to write these from scratch fairly quickly. Within one to three hours of just some video lectures, you can start writing this and start doing this on your own. Pretty awesome, right? And if you just want this, go grab it in the description below. Enjoy. 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