3

I know that there is a way to set a default font on Google Docs, but I was wondering if there's a way to set a default font in Google Sheets?

3

As far as I can find online, there is no way easy way to set a default font on Sheets.

The only thing I could find on the subject is this Product Forum post from 2016: "This does not work on Google Sheets. It even says that in the Help article that you linked to: "Note: At the moment, this feature isn't available for spreadsheets."

1

As the OP already said on their answer, at this time this is not a built-in Google Sheets feature, but there are some workarounds that we could use:

  1. Use a spreadsheet as a template to create new spreadsheets.
  2. Use an add-on / script to make it easier to set cell formats.
0

When starting a document, select all cells, then select the font, font size, etc... you want. These will be applied to all cells of the sheet and will therefore constitute a "default font" on your sheet. Once you are satisfied with the settings, you can save your blank file as a template, and duplicate it whenever you want to create a sheet with the same "default font"...

  • Good try, but whenever you enter new text into a cell in google sheet. It changed the font color /style back to the "google default" one overwriting the previous setting of the whole google sheet. I suspect that it is a bug in Google Sheet. Entering new text should NOT overwrite existing color styling of that cell. .... Long sigh.... – GeorgeW Mar 21 at 5:49
0

I've found that if you highlight the entire sheet and change the font, and then ensure to double click inside the cell before typing, it will keep the new default font.

Not the easiest, but it works for me.

0

The best way to keep formatting is to add rows or columns in the middle of the sheet instead of at the end.

If you insert a row then it will insert the row with the formatting (font, etc.) of where you're inserting. Definitely not ideal but better than nothing.

0

This feature is not currently built into Google Sheets, which is a ridicules as it's integral for productive workflow.
I have found a much easier work around then what was provided in this thread so far.

I saw there was a table styles add-on you could include, but it did not install for me.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.