Sort Sheet and Sort Range

Sorting reorders rows; it does not change any value. The distinction that matters is what gets reordered. Sorting the whole sheet by one column moves entire rows together, so every value stays with the record it describes. Sorting a selected range reorders only the cells in that selection, leaving the rest of the table where it was.

Google Sheets offers both: Sort sheet sorts the whole sheet by the chosen column and moves entire rows together, while Sort range sorts only the group of cells you select. Excel has no separate Sort sheet command. When the selection sits inside a larger block of data, it asks whether to expand the selection. Expanding extends the sort to the adjacent data region, so the related columns and rows are sorted with the selected one; it covers that block, not every cell on the sheet, and it stops at the region or table boundary. Continuing with the current selection sorts only the selected cells, which matches Sort range. Expanding therefore corresponds to Sort sheet only when the table is the sheet’s data region.

Sorting a range is appropriate for a standalone list or for a selection containing every related column of the table. Sorting only part of a record can instead pair reordered values with untouched values from another row. No error appears, the result looks orderly, and the damage is invisible without the original order to compare against. Undo is the only cheap repair, which is why a copy of the sheet is made before cleaning begins.

Two habits remove the risk. Select the entire table before sorting rather than clicking a single column header, and confirm the “Data has header row” option, which prevents header text from being sorted in among the records. Multi-level sorts — by region, then by date within each region — follow the order the conditions are listed in. Where the original order must survive, a SORT formula returns a sorted copy elsewhere and leaves the source untouched.

References:

• Sort and filter your data
• Sort data in a range or table