google-sheetsfrozen-columns

google spreadsheet freeze column and row

I have google spreadsheet with some schedules.

I froze first 3 lines.

Question:

How can I froze last column in same sheet?

Note: want to froze RED area

Output:

output

Solution

  • As Google Spreadsheet doesn't allow freezing by coloumn number, you will have to use app script.

    Gsheet - Tools - Script Editor

    function myFunction() {
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheet = ss.getSheetByName("yoursheetname");

 // Freezes the first column
 sheet.setFrozenColumns(1);
}

    More here

    Freezes the given number of columns. If zero, no columns are frozen.

    Not underestimating you - but still explaining bit by bit so that if required someone else can use it as well...