Hey there stranger!

Sign up to get access.

Change the Default Font

About this Tutorial

Set a different default font for each sheet you open.

Video Transcript

 Hello. Welcome to today's tip. We're gonna change the default font. Why would you wanna change the default font? Well, because sometimes if you change the text on your sheet and then you use command slash. To Unformatted, it goes back to the font that's default, which is aeriel. Sometimes you want a hundred percent.

You know that every font in your sheet is going to be Oswald Comforter, Aeriel new, or Comic San. If you're a crazy person But you don't want that. So what you do is you change the format theme to change literally this. What challenges await? Well, this is not transferrable to other sheets. So once we do it to this sheet, we have to do it to every sheet we ever wanna use, which is not a terrible problem to have.

It doesn't change the color background. We can change a lot of the colors we use in charts sort of some basic features. And the changes we make are only on the custom theme, which I'll show you in a second.  I talk a lot about my favorite fonts cuz Aeriel is a terrible font to have to look at all day every day.

If you're using Sheets 10 hours a day, then check out better sheets.co. I'm giving a lifetime access to all of my tutorials. We go deep into what are the, my favorite fonts and why they are, and you'll be able to even add more fonts. I tell you about this cool thing where you can. Actually go to and add more fonts than you ever imagined.

So how do you change the default font is you go to format. And over here you have themes. So you go format, theme, and you can click on any of these existing themes. Let me move my face over here. And there's some like really nice themes here to choose from. But you have your own particular font you want.

So you just click customize and what it is gonna do is it's gonna create a custom one. We can actually go standard customize, and now we can change the font here, aerial. We want to change it to courier new and we could change all these colors. These colors are for like charts, chart background. You just can't change your background color.

But it also does mention that edits to this will be saved over the existing custom. So you don't have multiple custom themes, you only have one theme. You just wanna change this. Click done. And now if I go here and I command slash to unformat it, it unformat two, the courier new, which is my default font now.

So now I don't ever have to change this font. It's actually the default. And that's how you change a default. It's not transfer again, it's not transferrable to any other sheets you make. It doesn't change the background color. If you wanna learn about why cheating the background color is really important, go to Better sheets.co.

I talk a lot about just making sheets experience better because we spend time in Google Sheets and you can make a very nice background that's a little easier on the eyes by just doing FB FB F eight that makes it look like paper. That's a little teaser for you. Check out better sheets.co. And that's what it looks like.

Nice paper, better sheets.co for more tutorials, free tutorials there. But also pay for full access, full lifetime access. I'll never charge you again for all the videos that exist. Thanks. Bye.


Better Than Happy | Redesign of The Feelings Wheel

How Starter Story Designs Data

Learn to Love Your Sheets

Best Header Font Ever

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


10 Things I Hate About Your Spreadsheets

Dark Mode / Better Font Color


Better Font Colors


Magical Things You Can do with Checkboxes in Google Sheets


How To Export Your Beautiful Sheets to PDF


Consider Labels as Opposed to Headers


Add Icons To Your Sheets With a Domain Name


How To Color Cell Blocks So Others Enter Data Easily


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!


Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!