79% OFF online library of tutorials for mastering Google Sheets
This tutorial is not available for free users. Please purchase a subscription to view this tutorial.
Hey there stranger!
Please sign-up or sign-in to watch this tutorial.
Best Header Font Ever
About this Tutorial
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.
0:22 The if you watch any other videos here about fonts, you know, probably my favorite car my favorite font is Carla.
0:29 I was gonna say my favorite Carla is font. That's not right. My favorite font is at this time, Carla Font.
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.
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.
0:56 Like it, it has different look and feel than aerial. 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.
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?
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.
1:28 You do all of this other stuff. 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.
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.
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.
1:57 But what about the fund? There is something to be said about just changing the font and almost nothing else. So no matter what, even if you use a, it's completely different font.
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.
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.
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.
2:33 And you can see it here, Oswald. There we go, Oswald, we might have to initiate it. Get it from more fonts.
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.
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.
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.
3:14 So this is not a monospace font. 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.
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.
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.
3:52 We can also take down the color a little bit and let's even put it in the center. Center it right now, right?
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.
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.
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.
4:31 Aerial and, and Oswald still are starkly different. So it's a stark contrast between your header and your data. But all you need to do is change the font.
4:41 We don't have to add some color. We could add color if we really want. And I just want to give you one bonus thing in this video.
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.
5:04 Take away all the grid lines and only put the grid lines on your data, or even just on the inside.
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.
5:24 So you can see, oh, this is the header. This is really easy to do. Couple clicks, and you're done, right?
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.
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.
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.
5:56 Your header Is going, going to be different than your data. 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.
6:11 Thanks for watching this video. Bye.
Better Than Happy | Redesign of The Feelings Wheel
Best Header Font Ever
Learn to Love Your Sheets
Sheet Review! 150 Active VCs by LemonIO
Anika Asks: How To Set Text Overflow All The Time
Introducing: Brutal Calendar
Add a Checkbox to Turn on Dark Mode
Create Drop Shadows! This makes your dashboards pretty.
Merge Cells for Dashboards
Dark Mode / Better Font Color
Better Font Colors
Magical Things You Can do with Checkboxes - Google Sheets
Export Your Beautiful Sheets to PDF
Consider Labels as Opposed to Headers
Add Icons To Your Sheets With a Domain Name
Coloring Cell Blocks for Others to Enter Data
Great Sheets! Corona Hiring Sheet
Great Sheets! Community Information Board by Seedtable.com
Roast: Hotel PPC Channel Cost Calculator
Better Header Fonts - Best Fonts To Use In Google Sheets
Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell
Basic Keyboard Shortcuts To Speed Up Your Productivity
Basics - 5 Ways to Change Row Height
Anders Asks: Can I Highlight Whole Row if Certain Columns have text?
How to Refer to Other Cells - A1 and R1C1 Explained
Change the Default Font
Biggest Flaw In Dashboards with Dark Colors
Basics - 4 Ways to Change Column Width
Basics - Structure of a Sheet: Index() Row() and Column()
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets
Use Cmd + Y To Do It Again, and Again, and Again
Create an Auto-Update Sales Chart: Trailing 12 Months
Google Sheet Basics - The Absolute Basics
Secure Your Sheets by BetterSheets.co
How To Create An AutoFill in Google Sheets
Build a Thermometer for Savings Goals
Make Your Lists Spicy Hot in Google Sheets
Restrict Access to a Cell if Another Cell is Blank
How to Use Smarket
Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!