sorting columns in online spreadsheet

I sorted a column, but the rest of the columns remained the way they were prior to the sort... meaning that now I had the sorted column having no relationship to the rest of the spreadsheet. Ugh!!