How to sort in Sheets

 

How to sort Sheets

Sorting data in a worksheet can help you find values easily, where you can rearrange a range or table of data based on one or more data columns. For example, you can sort the names of your team from A to Z.

 

How to sort in Sheets for Windows

1. Highlight the data that you want to sort


 

2. Click on the Data tab in the top ribbon, followed by Sort.

 

 

3. You can then sort the data alphabetically, from A to Z, or from Z to A. You can also select Custom Sort to fine-tune your choices.

 

 

 

 

Sort data in Sheets for Android

  1. Highlight the data that you want to sort by tapping on the cell from where you want to start and dragging along the handle.

  2. Then click on Home, which is located on the top ribbon.




3. Choose Data from the dropdown menu that appears.

 

 

4. Tap on the Sort button on the top ribbon.

 

 

5. This will then bring up the options you can use for sorting in your Sheet.

 

 

 

 

Sort in Sheets for iOS

1. Highlight the data that you want to sort by tapping on the cell from where you want to start and dragging along the handle.

 

 

2. Click on the Data tab, which is located on the top ribbon.

 

 

3. Tap on the Sort button on the top ribbon. This will then open a box where you can fine tune your preferences.

 

Was this article helpful?

0 out of 1 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.