Using the same set of data above, this time, we want to sort the data based on zip code but specifying the range of cells. It helps to avoid mixing up the information by specifying the size of the data set. Often a specific range of cells is selected for sorting as there are other sets of data available in the same spreadsheet, or only a specific part of data is required in the analysis. The city names under column A are now sorted alphabetically from A to Z, with the corresponding zip and state name intact.
In this demonstration, it’s A2 (Los Angeles). There’s also only one set of data available in the designed spreadsheet. In the example below, we will sort these city names alphabetically, from A to Z.
When sorting is applied, the corresponding information in the row moves up or down accordingly. To sort the entire spreadsheet, the data is always organized by a specific column.
