Sorting and Custom Sort

Sorting reorders whole rows by one column. Click a cell in the column you want to sort by and choose Sort A→Z (smallest first) or Z→A (largest first). Excel keeps each row together so products stay next to their sales.