Google-sheets – Make first row in Google Spreadsheet column names

google sheets

I cannot figure out how to turn the first row of a Google Spreadsheet into column names so that I can sort the spreadsheet by column without losing the variable names at the top of the spreadsheet.

I mean that I want to sort by column without losing the column names, which are currently stored in the first row.

Best Answer

Select your table range.
Right click on the range, select "Sort Range".
Then select "Data has header row" and define your sorting.

enter image description here

Related Solutions

Google Sheets – Make New Responses Appear at Top

I would simply suggest that you use the Timestamp column to sort the rows from new to old (Z-A).

Google-sheets – How to make some data Autosort in a spreadsheet on edit

This piece of code works:

function onEdit(){
  var sh = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var editedCell = sh.getActiveRange().getColumnIndex();

  if(editedCell == 2) { 
    var range = sh.getRange("A2:B10");
    range.sort({column: 2});
  }
}

One key difference is the .getColumnIndex. Without it you don't receive an integer !!

See example file I've created: sorting

Best Answer

Related Solutions

Google Sheets – Make New Responses Appear at Top

Google-sheets – How to make some data Autosort in a spreadsheet on edit

Related Topic