Skip to Content

How to Change Default Font in Google Sheets – Beginner’s Guide

Google Sheets is one of the best spreadsheet programs of 2024. It boasts an online editor and offers various tools for data organization and analysis. You can easily add a personal touch to your spreadsheets with a range of Google Fonts available.

Often, we feel like improving the aesthetics of our Google Sheets, and it starts with font styles!

Google products use “Arial” as a default font, which looks decent. But it is not designed to attract eyeballs.

This is a quick guide about how to change default font in Google Sheets. It will help you impress friends and colleagues by creating fantastic spreadsheets.

Click on the following links to jump to that particular article section.

Now, without any further ado, let’s begin.

How to use Theme settings to change default font in Google Sheets

Here are your options while selecting the default font in Google Sheets.

how to change default font in google sheets

In this section, we will learn to change default font in Google Sheets with one of the fonts listed in the above image. If you wish to select a different font style than the one listed above, you can do it. We will discuss that in the upcoming section of the article.

The steps are pretty simple, but make sure you come up with the best font for your needs.

  • Open a new Google Sheet by clicking here
  • Hover to the main menu
  • Click on the “Format” tab
  • Select the first option named “Theme” from the popup
  • A new dialog box will appear on the right side of the screen. Refer to the following image
  • Make sure that the first theme, called “Standard“, is selected
  • Now, press the “Customize” button at the top of the dialog box
  • A range of theme options will be displayed as shown below
  • You need to click on the dropdown below the “Font” option
  • Select the desired font. For the sake of this article, let us choose “Comic Sans MS
  • Click on the “Done” button at the top

Now, for this particular Google Sheet, the default font is changed to Comic Sans Ms.

If predefined fonts don’t impress you, then follow me along.

How to add more fonts to Google Sheets

I know it all starts with that special font you wish to use.

So, let us learn to add new fonts in Google Sheets. It is pretty straightforward.

For the sake of this article, let us consider the trending Google font Oswald.

Here are the steps,

  • Open the Google Sheet
  • Hover to the toolbar section that sits below the main menu
  • Click on the font dropdown as shown in the following image
  • A popup will be displayed with a list of prebuilt fonts
  • Click on the “More fonts
  • A new dialog box will appear, as shown below
  • Use the search to find the Oswald font
  • Click on the empty box and type “Oswald
  • Press the magnifying glass icon beside the search bar
  • Select the first option, and it will appear in the My Fonts section of the dialog box. Refer to the following image

    (Note that you can repeat the above 3 steps and search and add multiple fonts simultaneously)
  • Click the “OK” button of the dialog box to close it

Now, to see the font we just added, you need to click on the font dropdown of the toolbar section and scroll down until you find the font name.

You don’t need to be an expert to add a font to Google Sheets.

There are hundreds of fonts available for free. Make sure to sort the list by your specific language script or type, such as Sans and Sans Serif.

In the previous section, we learned to add a trending Google font in Google Sheets.

It will be available whenever you open a new Google Sheet. But, you need to enable it and then use it.

Here are the steps,

  • Open the desired Google Sheets
  • Click on the empty box at the upper-leftmost corner of the spreadsheet. Refer to the following image
  • All of the cells of the spreadsheet will be selected
  • Go to the toolbar section
  • Click on the Font dropdown
  • Scroll down until you see the font “Oswald” and click on it
    (You can select any other font of your choice, but make sure you add it to the Google Sheets by following the steps discussed in the previous section)

Now, for this particular spreadsheet, the font style is selected as the “Oswald”. You need to repeat the above process for the rest of your spreadsheets.

It is quite a lengthy process if we consider a lot of spreadsheets. However, that is the only way to use a trending Google font in Google Sheets.

How to change default font using Apps Script

This is a bonus tip on this list. If you are an expert at Google Sheets and aware of using Apps Script, then it is for you.

Apps Script enables users to automate repetitive tasks and save time.

We will use the same font used in the previous sections.

But note that the Apps Script is used to change the font style for a table range instead of the entire spreadsheet and Google Sheets.

So, let’s consider the table with table range “A1:C10“.

Here are the steps to use the Apps Script to change the default font style.

  • Go to the main menu
  • Click on the “Extensions” tab
  • Select the “Apps Script” from the popup
  • You will be redirected to a new tab in your browser, as shown in the following image
  • Click anywhere in the editor and press “CTRL +A” to select all
  • Press “BACKSPACE” to delete the existing code
  • Now, copy and paste the following code
  • Click the “Save” icon from the toolbar of the Apps Script window
  • Next, you need to click the “Run” button from the toolbar section
  • A new dialog box will open, as shown below
  • Click on the “Review permissions
  • Now, a separate window will be displayed where you need to select your Google account
  • A warning will appear. Don’t worry and click on the “Advanced” button
  • Click the “Go to Untitled project (unsafe)” button
  • Now grant the permission to Apps Script to make changes to your Google account by pressing the “Allow” button
  • You will be taken back to the Apps Script tab
  • In the Execution log section, you will see the success message as shown below

Now, if you go back to the Google Sheet and look at the table, the font will be changed to “Oswald“.

In case of different tables and fonts, make sure to edit the following section of the code.

FAQs (How To Change Default Font in Google Sheets)

Q. Why do you need to change the default font in Google Sheets?

There are many instances where you need to use a special font.

  • Fonts play a crucial role in the branding of a company
  • Arial is a decent font and doesn’t impress all the Google Sheets users
  • Aesthetic enhancement of a spreadsheet starts with the font style

These are only a few of the examples. In your case, the scenario may be different, but changing the font is guaranteed to help you with presentation and branding.

Q. What font is used in Google Sheets?

In most of the Google Products, you will find that the “Arial” is the default font.

Google Sheets is no exception here. Arial is used as the default font.

You can change the default font easily by following the steps mentioned in this article. It is pretty straightforward and hardly takes a few minutes.

Q. What is the best font to use in Google Sheets?

There are hundreds of Google fonts available for free. All of them are professional and attractive at the same time.

As of 2024, the most popular Google fonts are as follows,

  • Roboto
  • Open Sans
  • Poppins
  • Lato
  • Oswald
  • Montserrat
  • Source Sans Pro
  • Raleway

I mostly prefer working with the Poppins and Montserrat.

You can follow the above mentioned steps to view and add popular fonts in Google Sheets.


Thanks for reading the article till the end.

If you are interested in more tips and tricks for using Google Sheets like a pro, then please explore our blog section.

Changing the default font style in Google Sheets is pretty straightforward.

However, if you are stuck somewhere or having any particular issue, then feel free to comment below.

We suggest adding the desired font to the Google Sheets, and whenever you open a new spreadsheet, manually enable that special font. It is pretty easy and takes only a few seconds.