In this article, we'll show you how to rearrange cells in a column in Google Sheets on Windows and macOS to sort their data according to the specified options.
Step 1. Open Google Sheets in a web browser
In the address bar of your browser, type sheets.google.com and then press the ↵ Enter or ⏎ Return key.
Step 2. Click on the required file
Do this on the list of tables stored in Google Sheets.
Step 3. Select the column whose data you want to sort
To do this, click on the letter of the column at the top of the table. The entire column (all its cells) will be selected.
Step 4. Click Data
You will find this option in the menu bar under the file name (in the upper left corner of the screen). A menu will open.
Step 5. Click Sort Range from the menu
A pop-up window appears where you can specify the sorting options.
- This will sort the data in the selected column, but not the data in the other columns.
- To sort all of the table data according to the sorting options for the data in the selected column, from the Data menu, choose Sort Sheet By Column.
Step 6. Select a sorting method
To do this, check the box next to the "A> Z" or "Z> A" option.
- If you select the "A> Z" option, the numerical data will be sorted from minimum to maximum, that is, lower numbers will be displayed in the upper cells, and large numbers in the lower ones.
- If you select the Z> A option, the upper cells will display larger numbers and the lower ones smaller ones.
- If the first row of the table contains column headings, in the pop-up window, check the box next to Data with a header row. This will exclude the data in the first row from sorting.
Step 7. Click the Sort button
The data in the cells of the selected column will be sorted according to the selected sorting method.