D
D
Dima2020-09-01 10:08:25
Google Sheets
Dima, 2020-09-01 10:08:25

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 answer(s)
G
Grigory Boev, 2020-09-01
@qpz

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 question

Ask a Question

731 491 924 answers to any question