Answer the question
In order to leave comments, you need to log in
How to format text on all sheets of Google Sheets at once?
I have a google spreadsheet with 10 sheets. I want to change the font in each. Are there extensions or ways that can do this for the entire table as a whole?
Answer the question
In order to leave comments, you need to log in
1) Record actions on one sheet
with a macro recorder 2) Edit the script so that it works on all sheets
3) Run the function
let sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var sheet in sheets){
// do something
// Очередной лист - sheets[sheet]
};
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question