Members-only tutorial
Watch the video and get the practice sheet with membership.
About this tutorial
Annotated transcript
16 formulas linked inline Click any highlighted terms to learn more.<div>0:01 Hello, welcome. So in this video, we wanna go over header fonts. Well, actually only one header font rules them all, and we will go over what that header font is.<br>0:12 But I wanna start off with what we're trying to do and get to the header font eventually. So when we start a Google sheet, we have the default aerial font.<br>0:22 The if you watch any other videos here about fonts, you know, probably my favorite car my favorite font is Carla.<br>0:29 I was gonna say my favorite Carla is font. That's not right. Best Header Font Ever for Google Sheets Change Font on Every Sheet Tab
My favorite font is at this time, Carla Font.<br>0:35 And I usually say, you know, change everything to Carla. Just that if, if you don't do anything else, you can just go to more fonts, find Carla and get it into your system early and use it off.<br>0:48 Use it early, use it often. It is a great font. It is thin it is. Well, e e easy to read, well done.<br>0:56 Like it, it has different look and feel than aerial. Best Header Font Ever for Google Sheets
But what we're gonna end up doing if we use Carla everywhere, is that we have the, still the classic problem, sort of the same problem as we have, no matter what, which is our header .<br>1:12 And our data 's gonna look the same. And you probably go through this problem and you're probably like, Hey you know what?<br>1:18 I can bold my header . I can make my header bigger. Probably put some kind of black, or maybe not black, but maybe a thin pastel.<br>1:28 You do all of this other stuff. Best Header Font Ever for Google Sheets Start Sheeting Better in 2026
And what happens is that our headers and I go over this in another video, especially for better sheet members, I go deep into this.<br>1:37 And basically what this happens is our header becomes like the brightest point, but we actually want our data to be bright and our data to be seen.<br>1:46 The headers you just need to reference . And so in a whole nother video, I talk about why you should not do what I just did here, and you should actually have much smaller headers .<br>1:57 But what about the fund? There is something to be said about just changing the font and almost nothing else. Best Header Font Ever for Google Sheets How to add Header AND Footer Colored Rows
So no matter what, even if you use a, it's completely different font.<br>2:07 If you use Aeriel, if you use Carla, no matter what, what we could do is just change our font of our header and it will look completely different.<br>2:15 And that's what this font does differently. And the font is Oswald. So, and it's very little used because it is in the O's.<br>2:25 Probably the most used fonts are in the A's, BS, and C's, but it is in the o's. You have to scroll down, or we can also click on more fonts.<br>2:33 And you can see it here, Oswald. There we go, Oswald, we might have to initiate it. Best Header Font Ever for Google Sheets How to Change Font Size
Get it from more fonts.<br>2:40 Now this, you almost only have to do this, change your font. Now there is a stark difference between our header and our data , and our header is not like bright in our face.<br>2:54 It is a little bit bolded. So Oswald is also skinnier. So it's a little, little bold, one good thing. So we don't have to bold it.<br>3:02 We can, if we want we can hit bold. I don't necessarily like that, but you don't have to. It looks a little bit thicker and it's skinnier, meaning you can actually get more letters in.<br>3:14 So this is not a monospace font . Best Header Font Ever for Google Sheets Why My Number Fonts Terrible?
So n not all characters will be the same. I think we can do, like, let's see, yeah, the eyes are gonna be very thin.<br>3:28 Tees are even thin, whereas you have a thicker tea on your Carla. Also, if you notice here between Oswald and Carla, Carla has a lot more space between the letters.<br>3:38 Oswald shrinks that all down. We can even bring this up to a higher font size. And it looks great. It looks like a header without having to do all of the other stuff to it.<br>3:52 We can also take down the color a little bit and let's even put it in the center. Best Header Font Ever for Google Sheets
Center it right now, right?<br>4:03 We have separated our header from our data in a way. We don't have to work with colors. We don't have to work that much with size because it's a little bit bolder.<br>4:12 It's a, it's a different kind of font. Oswald I find is just the best header font ever. It is so good, and I hope you start using it here.<br>4:23 And I hope you start using Carla. If you haven't used Carla yet, go ahead and use Carla. Even if you don't use Carla, let's go back to aerial here.<br>4:31 Aerial and, and Oswald still are starkly different. Best Header Font Ever for Google Sheets Start Sheeting Better in 2026
So it's a stark contrast between your header and your data . But all you need to do is change the font.<br>4:41 We don't have to add some color. We could add color if we really want. Best Header Font Ever for Google Sheets How to add Header AND Footer Colored Rows
And I just want to give you one bonus thing in this video.<br>4:50 If you end up wanting to get a little bit more contrast, but you don't wanna increase the size of your head or anymore, you don't want to decrease colors or anything, what you could do is go to up to freeze , sorry, not freeze , view grid lines.<br>5:04 Take away all the grid lines and only put the grid lines on your data , or even just on the inside.<br>5:13 Now our headers are completely different and starkly different because they have a big gap, a big a lot of white space, more white space between them and the data than the data itself.<br>5:24 So you can see, oh, this is the header. Best Header Font Ever for Google Sheets How to add Header AND Footer Colored Rows
This is really easy to do. Couple clicks, and you're done, right?<br>5:30 You don't have to mess with much of the again, all the normal stuff you're doing to your headers . Now you are putting them with a darker background.<br>5:40 You're putting them, making them bigger. You're making them all different. Bolding them, right? No more. This looks a lot neater.<br>5:49 It look looks a lot nicer. You can also say make sure that the fonts are all the same sizes and they're still gonna be starkly different.<br>5:56 Your header Is going, going to be different than your data . Best Header Font Ever for Google Sheets Start Sheeting Better in 2026
This is really cool for making kinds of tables or any kind of data where you need a little bit of hierarchy but you don't want to really do something crazy with your headers that you might normally be doing.<br>6:11 Thanks for watching this video. Bye.</div> Best Header Font Ever for Google Sheets How to Add Alternating Row Colors