One very useful feature of spreadsheets is sorting. However, we have to be sure Sheets knows which data to sort and which data to leave in place.
|To do this||Do this|
|Lock header rows in place||Click on the row, and choose View ⇒ Freeze ⇒ Up to current row.|
|Sort the whole sheet||Click on the column, and choose Data ⇒ Sort sheet by column.|
|Sort part of the sheet||Select the region to sort, and choose Data ⇒ Sort range by column.|