I have a Google Sheets containing nearly 50 sheets. I need to apply the freeze option for all the sheets.

For a single sheet I applied the freeze option by View -> Freeze -> 1 row.

Is there any way to apply the same freeze option for all the sheets in an easy way, instead of manually applying the freeze option in the 50 sheets?

1 Answer 1


No, not without something like Google Apps Script (see for example here).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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