Sort Names Alphabetically and Keep Related Numbers Together in WPS Spreadsheets
Question details
Sort names in column A alphabetically without separating their corresponding values in column B.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user needs to organize a two-column list by name while preserving each name-and-number relationship.
- Observed behavior
- Each complete row should move together so that every value in column B remains matched with the correct name in column A.
Make sure there are no completely blank rows or columns inside the list, because they can split the data range. If your first row contains labels such as Name and Number, keep it included so you can identify it as a header in the Sort dialog.
Sort the complete name and number range by column A
Use this method when names and numbers are related records that must stay together on the same rows.
Selecting both columns before sorting ensures that WPS Spreadsheets rearranges full rows rather than sorting only the names.
Drag to select the full range that contains the names in column A and the related numbers in column B, including headers if your list has them.
On the ribbon, click Data > Sort to open the sorting options.
In the Sort dialog, set the Sort by field to column A or to the Name header. If headers are included, enable the option indicating that the data has headers.
Choose Ascending or A to Z, then click OK. WPS Spreadsheets sorts the selected rows by name and moves the matching column B values with each row.
Expand the selection when sorting from a single name cell
Use this option when you started sorting from one cell in column A and WPS asks whether to expand the selected range.
Sort Related Name and Number Records Easily in WPS Spreadsheets
WPS Spreadsheets lets you sort a complete table by a name column while keeping all related values aligned in their original rows. Select the full range, choose the column to sort, and apply A-to-Z order from the Data tab.
- 1. Open the worksheet: Open your .xlsx, .xls, or WPS spreadsheet in WPS Spreadsheets.
- 2. Highlight the table: Select the complete data range, including the name and related number columns.
- 3. Choose Sort: Click Data > Sort on the ribbon.
- 4. Sort by names: Select column A or the Name header, choose Ascending, and click OK.
Frequently Asked Questions
Why did the numbers no longer match the names after sorting?
This usually happens when only column A was selected and sorted. Undo the action if possible, then select both the name and number columns before choosing Data > Sort.
Should I include the header row when sorting names?
Yes, you can include it. In Data > Sort, identify that the selected range has headers so WPS Spreadsheets uses the Name header as the sort field and does not move the header into the list.
Can I sort names from Z to A and keep the numbers together?
Yes. Select the complete range, click Data > Sort, choose column A or Name, and select Descending or Z to A. The corresponding numbers move with each row.
What should I choose if WPS asks whether to expand the selection?
Choose Expand the selection when the adjacent column contains related values. This includes column B in the sort and prevents names from being separated from their numbers.
Can I sort a table by names and then by numbers?
Yes. Go to Data > Sort, set the first level to the Name column, then add another sort level for the Number column. WPS Spreadsheets keeps each complete row together during both sorts.
