sodcalculator

10 Tech How-To

Change Default Font in Google Sheets: Easy Steps

Guide 10-45734 · Updated · Step by step

This guide shows you how to set a default font in Google Sheets so every new spreadsheet you create uses your preferred typeface and size. You only need a Google account and a browser—no extra software required.

What You’ll Need

  • A Google account (free)
  • Access to Google Sheets via a web browser
  • An existing spreadsheet (to test the settings) or a new blank one

Step-by-Step

  1. Open Google Sheets. Go to sheets.google.com and sign in. You can also open Sheets from Google Drive by clicking New > Google Sheets.
  2. Create a new spreadsheet. Click the blank spreadsheet option (or open any existing file). The default font will apply to new files, so starting fresh makes it easy to verify.
  3. Select the entire sheet. Click the rectangle at the top-left corner of the sheet (between the column A header and row 1 header). This highlights all cells.
  4. Open the font menu. In the toolbar, find the font name box (it usually shows “Arial” by default). Click the small arrow next to it to open the font list.
  5. Choose your font. Scroll through the list or type the font name to search. Click the font you want to use. You can also change the size using the adjacent size box (e.g., set it to 11 or 12).
  6. Set as default. After selecting the font and size, go to the menu bar and click Format > Default font > Save as default. A confirmation message may appear; click OK.
  7. Test it. Create a new spreadsheet (File > New > Spreadsheet). Type in a cell—it should use your chosen font and size. If it doesn’t, repeat the steps and ensure you clicked “Save as default.”

Common Mistakes

  • Not selecting all cells. If you only select a few cells, the default only applies to those cells, not the whole sheet.
  • Forgetting to click “Save as default.” Simply changing the font in the toolbar does not set it as the default. You must use the Format menu option.
  • Changing the font in an old spreadsheet. The default only applies to new spreadsheets. Existing files keep their original formatting unless you manually change them.
  • Using a font that isn’t available on all devices. Some fonts may not render on mobile or older systems, causing fallback to a default font.

Tips

  • Choose a font that is easy to read for data, like Arial, Calibri, or Roboto. For headings, you might prefer a serif font like Georgia.
  • Set the default font size to 11 or 12 for comfortable viewing, especially if you share sheets with others.
  • If you want different fonts for different parts of your sheet, use styles (e.g., Title, Heading) instead of changing the default.
  • You can also set a default font for a specific spreadsheet by selecting all cells and applying the font—this is useful if you don’t want to change the global default.
  • Check how your font looks in print preview before sharing, as some fonts may alter page breaks.

Troubleshooting

If the default font doesn’t stick, try these fixes:

  • Refresh the page. Sometimes the setting doesn’t update immediately. Close and reopen the browser tab.
  • Clear browser cache. Old cached data can interfere. Clear your browser’s cache and cookies, then try again.
  • Try a different browser. If the issue persists, test in another browser (e.g., Chrome vs. Firefox) to see if it’s a browser-specific problem.
  • Check if you’re in Incognito mode. Incognito mode may not save settings. Use a normal window.
  • Verify your account permissions. If you’re using a work or school account, an administrator may have locked default settings. Contact your IT admin.
  • Use the mobile app? The default font setting is not available in the Google Sheets mobile app. You must use the desktop web version.

Frequently Asked Questions

Does changing the default font affect existing spreadsheets?

No, it only applies to new spreadsheets created after you save the default. Existing files keep their original formatting.

Can I set different default fonts for different types of documents?

No, Google Sheets only allows one global default font for all new spreadsheets. You can, however, manually change fonts per sheet or use styles.

Why does my font change back to Arial when I share the sheet?

If the viewer doesn’t have the font installed, Google Sheets may substitute a default font. To avoid this, use common fonts like Arial, Calibri, or Times New Roman.

Can I set a default font for a specific spreadsheet only?

Yes, select all cells (or the range you want) and apply the font. This will be saved with the spreadsheet, but it won’t affect other files.

Is there a way to set the default font in Google Sheets on mobile?

No, the default font setting is only available in the web version. On mobile, you can change the font for selected cells but not set a global default.

What if I want to use a custom font not in the list?

Google Sheets only supports fonts available in its font library. You can’t upload custom fonts. However, you can use Google Fonts that are integrated into the app.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →