Highlight the rows by holding down the Shift key and clicking on the row numbers you want to sort. Right-click on the selected area and select Sort Rows. In the Sort form, enter your sort criteria and click OK.
Follow the step-by-step instructions to learn how to sort information on your sheet. To organize your data in ascending or descending order, use the Sort Row command. When you sort, you have two choices about the amount of data you want to work with: you can sort all rows in your sheet or only a selection of them.
To organize your data in ascending or descending order, use the Sort Row command. When you sort, you have two choices about the amount of data you want to work with: you can sort all rows in your sheet or only a selection of them. Here are some things to keep in mind as you sort: Applying a sort will impact the existing rows in the sheet.
1 Highlight the rows by holding down the Shift key and clicking on the row numbers you want to sort. 2 Right-click on the selected area and select Sort Rows. 3 In the Sort form, enter your sort criteria and click OK.
Why can’t I sort locked rows in a sheet?
Although Editors can sort a sheet, they can’t sort locked rows. If the Sort Rows option appears unavailable, and you’re shared to the sheet with Editor permissions (see Sharing Permission Levels for details), deselect any locked rows before attempting to sort. The Sort Rows command will be unavailable if a filter is applied to your sheet.
What should I keep in mind when I sort my data?
Here are some things to keep in mind as you sort: Applying a sort will impact the existing rows in the sheet. When new rows are added, you’ll need to sort again to incorporate the newly added rows. You cannot undo a sort after the sheet has been saved. Make sure the rows in your sheet are ordered as desired before you save it.
Why can’t I sort on a column in a dropdown list?
If you sort on a column that is a Dropdown List type in the source sheet, items won’t sort based on the predetermined dropdown values in the included source sheets. A report can pull from multiple sheets and will consolidate columns with the same name and column type.