Comments on: How To Use the Google Sheets’ Change Default Font Function (3 Easy Ways)

By: Bubba

Bubba — Thu, 04 Jan 2024 08:02:57 +0000

This doesn’t tell you how to change the default font SIZE.

By: SnowBol

SnowBol — Tue, 18 Jul 2023 16:01:52 +0000

The scripts has some corrections. For Times New Roman I applied this.

function changeFont() {

var ss = SpreadsheetApp.getActiveSpreadsheet()

var thisfont = ss.getSpreadsheetTheme().getFontFamily()

Logger.log(‘DEBUG: the starting font = ‘+thisfont)

var newfont = ‘Times New Roman’

ss.getSpreadsheetTheme().setFontFamily(newfont)

Logger.log(‘DEBUG: changed the font to ‘+newfont)

var currentfont = ss.getSpreadsheetTheme().getFontFamily()

Logger.log(‘DEBUG: post-change font is now = ‘+currentfont)

}

By: as

as — Mon, 22 May 2023 23:31:24 +0000

change all “s to ‘s.
like tom mentioned. otherwise you’ll get errors.
thank you.

By: Robert H

Robert H — Wed, 10 May 2023 21:33:11 +0000

Only six fonts to choose from? Why not all? 🙂

Robert

By: Christopher Daniel

Christopher Daniel — Wed, 14 Dec 2022 03:08:55 +0000

In reply to Elizabeth Z.. Open the spreadsheet you originally changed each time you want to start a new spreadsheet. Then use File > Make a copy to copy that spreadsheet. The new copy will have the settings you desire.

By: Christopher Daniel

Christopher Daniel — Wed, 14 Dec 2022 03:03:10 +0000

In reply to Roslyn Wythe.

1. Save an empty version of the sheet with the format settings you’d like.
2. Open the empty sheet every time you want to make a new spreadsheet.
3. Navigate to File > Make a copy and use the new sheet that you make.

By: Tom

Tom — Wed, 07 Dec 2022 11:22:18 +0000

Perfect!
I have just implemented the Script way of changing the default text in gSheets. (had to modify all the ” to ‘). This will make a huge difference for me.
Also looking for a way to force the text size from 10 to 11 and background from white to light grey
Thanks!

By: Roslyn Wythe

Roslyn Wythe — Wed, 18 May 2022 18:47:09 +0000

Creating a Google Sheet from a template with my favorite font / font size sounds great, but the instructions did not work for me. I wonder if I need the paid version. When I try to create a new Google Sheet from a template, my only option is the template gallery, with no option to use previously created Google Sheets.

By: Dee

Dee — Thu, 28 Apr 2022 00:57:24 +0000

For Option 1 – what if i dont want one of those 6 fonts ?

By: Elizabeth Z.

Elizabeth Z. — Mon, 14 Mar 2022 17:30:35 +0000

This did not work. I created a blank document as instructed, putting in my chosen font options, but when I went to Your step 1: “Open a new file Google Sheet from the template by navigating to File -> New -> from Template” only Google’s stock templates were there. In fact, File – > New only had two choices: “Spreadsheet” and “From template gallery.” There was nothing that offered the option “From template.”