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?
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."
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:
- Use a spreadsheet as a template to create new spreadsheets.
- Use an add-on / script to make it easier to set cell formats.
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"...
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.
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.
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.