Freeze rows and columns
set_frozenFreeze the first rows or columns of a Google Sheet so headers stay visible while scrolling. Specify counts, use 0 to unfreeze, and keep at least one row or column unfrozen.
Instructions
Freezes the first N rows and/or columns of a sheet so they stay visible while scrolling (typical: frozen_rows=1 pins the header). 0 unfreezes. At least one of frozen_rows / frozen_columns is required; the other stays as it is. You cannot freeze all rows or all columns of a sheet — at least one unfrozen row/column must remain.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_id | Yes | The numeric sheetId (NOT the title) from get_spreadsheet sheets[].properties.sheetId; the first sheet of a new spreadsheet is 0. | |
| frozen_rows | No | How many top rows to freeze (0 = unfreeze). | |
| frozen_columns | No | How many left columns to freeze (0 = unfreeze). | |
| spreadsheet_id | Yes | The spreadsheet id — the long id from the URL (docs.google.com/spreadsheets/d/<spreadsheetId>/edit) or from create_spreadsheet / search_spreadsheets output. |