Google Sheets is a powerful spreadsheet application that allows you to create and edit spreadsheets on the go. Among the customization options Google Sheets offers is the ability to change the default font. This article will walk you through how to change the default font in Google Sheets.
But first, why would you want to change the default font style? Well, changing the default font can Google Sheets To improve the overall aesthetics of the spreadsheet and make it stand out.
Whether you're creating a budget spreadsheet, a report, or a presentation, the right font can help you convey your message more effectively. With that out of the way, let's get started with the article.
How to temporarily change the default font in Google Sheets
It's easy to temporarily change the default font in Google Sheets. Select the Font option from the Google Sheets toolbar. Then, from the drop-down menu, select your preferred font.
Keep in mind that this isn't a permanent solution, meaning that when you open a new Google Sheets document, it will always open in the default font (Arial). This method is useful for those who want to work on a single document and don't want to create a theme or template for it.
However, keep reading if you want to permanently change the default font to your preferred font.
Read also: How to Convert an Excel Spreadsheet to a Google Sheets Document.
How to Permanently Set the Default Font in Google Sheets
There are several ways to change the default font in Google Sheets to your preferred font. We'll list two prominent methods. Let's get started.
1. Use custom theme settings
Setting up a custom theme allows you to incorporate your favorite settings and customizations, including font, color, etc. Follow the steps below.
Step 1: Go to Google Sheets Select Blank to create a new sheet.
Step 2: Click "coordination" From the drop-down menu, select "topic".
This will open the Themes side panel on the right. You'll see previews of each theme, which you can quickly select and edit.
Step 3: Locate Attribute that you want to customize and click Customize.
Step 4: Click an option Line Select the font from the drop-down list.
Step 5: Once selected, click It was completed.
This changes the default font in the theme to your preferred font. However, this doesn't make it a template for future documents. So, keep reading.
Step 6: Save this custom spreadsheet with a recognizable name, such as "line feature" , and tap Spreadsheet home page icon.
So, whenever you need to use spreadsheets, open the file. “The Font Theme” From the Google Sheets home page, follow the steps below.
Step 7: Once opened, go to Files and select Create a copy From the document from the drop-down list.
Step 8: Name the document and click the button. Create a copy.
Now, you can work on the document without changing the settings. Furthermore, the template document (with your settings) will remain the same the next time. If the steps are too long to follow, skip to the next method.
2. Use of application programming
Apps Script can be used in Google Sheets for various purposes, one of which is setting the default font. The steps may seem complicated, but they are easy to follow.
Step 1: Go to Google Sheets Select Blank to create a new sheet.
Step 2: Locate Additions And choose Script Apps.
It will take you to a new window where you can edit scripts.
Step 3: in Script Editor Remove the existing code, if any, and type or copy the code below.
Note: We've set the font to Roboto with a font size of 14. You can change this to whatever you prefer and even set a custom range.
function onEdit(e) { var ss = SpreadsheetApp.getActiveSheet(); var range = ss. getRangeList(["A2:E6"]); range.setFontFamily("Roboto") .setFontSize(14) .setFontColor("#000000") .setBackground("#ffffff"); }
Step 4: Once done, click save.
Step 6: At the required authorization prompt, click Review permissions.
Step 7: Log in with Google account Your.
Step 8: Now, click Allow.
Once you run the script, you'll see the font change when you return to your spreadsheet. However, this only affects the current Google spreadsheet. If you want to set the default font in Google Sheets to a new font using App Scripts, follow these steps.
Step 8: in Script Editor Type or copy the code below.
Note: We have used Roboto font style and font size 14. You can replace them with your preferred style in the code.
function changeSheetFont() { var ss = SpreadsheetApp.getActiveSpreadsheet() var sheet = ss.getActiveSheet() var thissheet = sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()) var newfont = "Roboto" var ss = SpreadsheetApp.getActiveSheet(); var range = ss. getRangeList(["1:1000"]); range.setFontFamily("Roboto") .setFontSize(14) .setFontColor("#000000") .setBackground("#ffffff"); thissheet.setFontFamily(newfont) var tabs = SpreadsheetApp.getActiveSpreadsheet().getSheets(); tabs.forEach( (tab) => { tab.getDataRange()})}
Step 9: Finally, tap save and run Script.
With this, you can set the default font and font size for the entire spreadsheet. If your preferred font is missing, skip to the next section to learn how to add it to your spreadsheet.
How to add more fonts in Google Sheets
Step 1: Go to Google Sheets Select blank to create. New paper.
Step 2: Click Fonts list From the drop-down menu, select More fonts.
You will be taken to the new font page where you can see all the fonts, including fonts for different languages.
Step 3: Locate Line which you select from the list and click OK.
That's it. With this, the font you added will appear in your main document, which you can use in current and future documents. If you have any questions, see the FAQ section below.
Tip: Get to know How to change the default font and size in Google Docs.
Frequently asked questions about changing default fonts in Google Sheets
Q1. Is it possible to have two different fonts in one cell on Google Sheets?
answer. Yes, it is possible to have multiple fonts in a single cell on Google Sheets. Here's how to do it: Select the cell(s) you want to format > Highlight the text within the cell you want to format > Click the Font option in the toolbar > Select the desired font from the drop-down menu.
Note: This method will only change the font for the selected text; the rest will remain unchanged.
Q2. What font does Google Sheets use?
answer. Google Sheets uses Arial as the default font for new documents and cells within existing documents. However, you can change this to any font you like.
Q3. What slows down Google Sheets?
answer. Multiple factors can slow down Google Sheets, including multiple cells, complex formulas, large data sets, add-ins and scripts, an outdated browser and device, multiple sheets, external data connections, and shared access.
Personalize your preferences
So, here's how you can change the default font in Google Sheets and make your spreadsheets stand out. Additionally, changing the default font to your preferred one can improve the readability of Google Sheets and make them more pleasing to the eye. You may also want to read about How to lock cells and rows in Google Sheets.
