To sort a range:
- Select the cell range you want to sort. ...
- Select the Data tab on the Ribbon, then click the Sort command.
- The Sort dialog box will appear. ...
- Decide the sorting order (either ascending or descending). ...
- Once you're satisfied with your selection, click OK.
- The cell range will be sorted by the selected column.
How do I sort Data in Excel without mixing Data?
Select a cell or range of cells in the column which needs to be sorted. Click on the Data tab available in Menu Bar, and perform a quick sort by choosing any one of the options under the Sort & Filter group, depending upon whether you want to sort in ascending or descending order.
How do you sort in Excel and keep rows together?
In the Sort Warning window, select Expand the selection, and click Sort. Along with Column G, the rest of the columns will also be sorted, so all rows are kept together. NOTE: When you're working with a table or filtered range, all rows are kept together automatically, and there is no need to expand the selection.
