Select the row below the one you want to freeze. This is useful when comparing specific rows within a sheet.Enter the frozen row’s name, and click on “OK.”. Under “General,” click on “Freeze Rows.”. On the resulting menu, click on “Options.”. Click on the icon in the upper-left corner of the spreadsheet that looks like three lines stacked on top of each other.
For e.g., you cannot freeze 2 rows (say rows 10 and 11) in. Google Sheets does not support freezing arbitrary columns and rows.
Similarly, use setFrozenColumns (N) to freeze N columns starting from the left. How to freeze a row in google sheets To freeze a row using Apps Script, use the setFrozenRows (N) method of the Sheet object where N is the number of rows at the top to freeze.
