So I am trying to order a column by alphabetical order of surnames. Obviously, the other columns like the names need to follow their respective surnames. How do I do that?
Click any cell in the surnames column.
Click the [A-Z] or [Z-A] button on the main toolbar.
This will sort the current region of cells by the selected column. The current region is the range around the currently selected cell(s) that is defined by content without gaps. The current region is bordered by emtpy cells.