we wanna change the font on every single tab, and we wanna do it automatically in a pretty simple and easy way. We just need a few lines of app script . Go up to Extensions app script , call this project change font. And here we'll write a new function called change to some font, and all we have to do is go variable ss equals spreadsheet app dot get active spreadsheet . That's the entire file. Variable sheets is equal to Ss. Get sheets. With parentheses. Now this gets us a list of every single sheet in the sheet spreadsheet , the all of the tabs, and so we go sheets dot four each. And here we need to write a little tiny function , which is for every sheet, this is going to be an what's called an arrow function .

We're going to execute this with a variable called sheet. So we're gonna go sheet GI range , and we're gonna go from the very first, A one cell until sheet do GI Max rose. Now again, this is just getting the entire sheet, all of the rows, comma sheet, get max columns. And this gets us every single cell in the entire sheet. Now, we could do get data range here, but that would only change the font in cells where there is data . We may want to change the font for the entire sheet. So even if we add more text later, that font shows up. So now we need to set font family. I just need one family, and this is where you enter in quotes, the name

of the font you want to change to. So we're gonna use quicksand in this particular case. Now, after this is done, if we don't get an error and we want to say, okay, we've actually done this change, we're gonna say spreadsheet app. Get UI alert. You've changed the font on all sheets, so we're gonna get an alert that says that now I'm gonna save this and I'm gonna hit run. It's gonna ask me to authorize first, but then it should execute the function . Continue authorized successfully. And now we go back to our sheet and we say you've changed the font on all sheets. Okay. Have we? There it is. So it did it, there's the font quicksand on all of the sheets. On every single sheet, it's quicksand everywhere. That's how you change the font on all your tabs.

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.