3 Ways to Change the Font Size in Google Sheets

This post is going to show you how you can change the font size in Google Sheets.

Gathering data is important. But the data must also be readable and easy to comprehend.

That is why spreadsheets have various formatting tools that can be used to make data easy on the eyes.

One format feature for Google Sheets that is extremely important, but often overlooked is the font size.

Here’s a quick test. Which dataset will you rather work with? The bottom is much easier to read with a larger font size!

Just like a word processor, the font in your spreadsheet must be a proper size so you can work with your data.

In this post, you will learn how to change the font size in your spreadsheet using the following methods.

  • The toolbar
  • The format menu
  • Apps script

Get your copy of the example workbook with the above link to follow along.

Change the Font Size with the Toolbar

Changing the font size on your spreadsheet is an easy task.

This is so because it is one of the few tasks in the spreadsheet where you don’t need any syntax or go through an elaborate number of steps to complete.

The font size command is easy to spot on the toolbar.

Follow these steps to use it to change the font size of the contents of a cell.

  1. Select the cell or cell ranges whose font you want to change
  2. Go to the the Font size dropdown.

You can use the dropdown arrow to select from the list font size options.

You can also double-click on the number inside the space to delete the existing size and enter a new one.

The benefit of using the double-click method is that it allows you to enter font sizes that are not available on the pre-set list.

💡 Tip: You can also change the font style from the toolbar for a more customized look.

Change the Font Size from the Format Menu

The Format menu contains all of the formatting options you need in your spreadsheet, including the option for changing the font size.

To change the font size from the Format menu.

  1. Go to the Format menu.
  2. Click on the Font size option.
  3. Select from the list of font size options.

You can follow the steps outlined earlier to change the font size in a cell.

Change the Font Size with an Apps Script

The apps script allows you to create custom functions that suit your specific needs. It’s a very useful tool for automating repetitive tasks such as changing the font size.

Go to the Extentions tab and select Apps Script to open the script editor.

function changeFontSize() {
  var spreadsheet = SpreadsheetApp.getActive();
  var range = spreadsheet.getActiveRangeList()
  range.setFontSize(14);
};

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Font')
    .addItem('Change Font', 'changeFontSize')
    .addToUi();
};

Copy and paste the above syntax into your code editor. Press the Save button and refresh your spreadsheet to Run the code in the onOpen() function.

When your spreadsheet refreshes, the syntax will create a new custom menu named Font which will appear in the menu options. In the submenu, you will find the Change Font option.

When you select the Change Font option, the font size of the selected cell or ranges will change to 14pts.

To change the font size of the script, simply edit the setFontSize method.

Conclusions

The font size doesn’t always get too much attention until the dataset has a font that is an uncomfortable size with which you can work.

With these methods, you can easily alter the font size in your Google Sheets datasets.

You can use choose a font size from the toolbar or the Format menu. But if you require standardized font size across all your sheets, then the apps script will be the most beneficial.

Do you know of any other method for changing the font size? Let me know in the comments below!

About the Author

Oluwaseun Olatoye

Oluwaseun Olatoye

Oluwaseun is a business intelligence analyst with expertise in Google Sheets and SQL programming language. He has worked with various businesses to make data-driven decisions. He enjoys helping others learn and grow.

Related Articles

Comments

0 Comments

Submit a Comment

Your email address will not be published.

Get the Latest Google Sheets Tips

Write For Us

Are you a tech enthusiast with a talent for writing great content? Come write for us!

Follow Us

Follow us on social media to stay up to date with the latest in Google Sheets!