Academy ↓
Hey there stranger!
Best Header Font Ever
About this Tutorial
Sheet Resources
Video Transcript
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.
Courses
Better Than Happy | Redesign of The Feelings Wheel
Best Header Font Ever
Learn to Love Your Sheets
How Starter Story Designs Data
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
00:05:10
Create Drop Shadows! This makes your dashboards pretty.
00:12:04
10 Things I Hate About Your Spreadsheets
Merge Cells for Dashboards
00:05:29
Dark Mode / Better Font Color
00:09:35
Better Font Colors
00:02:45
Magical Things You Can do with Checkboxes in Google Sheets
00:12:31
How To Export Your Beautiful Sheets to PDF
00:04:06
Consider Labels as Opposed to Headers
00:04:02
Add Icons To Your Sheets With a Domain Name
00:04:21
How To Color Cell Blocks So Others Enter Data Easily
00:10:30
Great Sheets! Corona Hiring Sheet
00:10:43
Great Sheets! Community Information Board by Seedtable.com
00:07:35
Roast: Hotel PPC Channel Cost Calculator
00:11:25
Better Header Fonts - Best Fonts To Use In Google Sheets
Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell
00:09:49
Basic Keyboard Shortcuts To Speed Up Your Productivity
00:13:44
Basics - 5 Ways to Change Row Height
00:05:08
How to Refer to Other Cells - A1 and R1C1 Explained
00:13:22
Anders Asks: Can I Highlight Whole Row if Certain Columns have text?
00:09:31
Change the Default Font
00:03:33
Biggest Flaw In Dashboards with Dark Colors
00:07:45
Basics - 4 Ways to Change Column Width
00:05:48
Basics - Structure of a Sheet: Index() Row() and Column()
00:06:49
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets
00:08:55
Use Cmd + Y To Do It Again, and Again, and Again
00:03:03
Create an Auto-Update Sales Chart: Trailing 12 Months
00:09:57
Google Sheet Basics - The Absolute Basics
00:09:48
Secure Your Sheets by BetterSheets.co
00:11:07
How To Create An AutoFill in Google Sheets
00:06:07
Build a Thermometer for Savings Goals
Make Your Lists Spicy Hot in Google Sheets
00:01:47
Restrict Access to a Cell if Another Cell is Blank
How to Use Smarket
00:03:28
Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!
00:06:23
Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!
00:53:31
Topics