Data Import & Export

Sort Excel Item Descriptions Alphabetically While Keeping Number Codes Matched

Adam DavisAdam Davis Nov 12, 2026 870 views

Question details

Sort item descriptions alphabetically while keeping each assigned number code in the same row.

Sort Excel Items Alphabetically While Keeping Number Codes Matched
Product
Microsoft Excel
Device & OS
not provided
Scenario
The worksheet contains related item and number-code data across multiple columns, and the user wants to alphabetize the item descriptions.
Observed behavior
The item description and its corresponding number code must remain matched after the sort.
Before you start

Identify every column that belongs to each item record before sorting. If your data has column headings, make sure the first row is a header so it is not included in the alphabetical order.

Solution 1Recommended

Sort the Entire Excel Data Range by Item Description

Use this method when the item descriptions and number codes are located in adjacent columns and must stay together row by row.

Select the complete related range rather than sorting only the description or number-code column. Excel then moves each full row together based on the item description.

1
Select all related columns

Drag to select the full table range, such as columns A:C, including the item descriptions, number codes, and any other fields that belong to the same records.

2
Choose the description column

Click a cell in the Item Description column within the selected range.

3
Sort from A to Z

Go to Home > Sort & Filter > Sort A to Z. If Excel asks whether to expand the selection, choose Expand the selection and select Sort.

Sort the Entire Excel Data Range by Item Description
Rows remain matched: Sorting the entire range ensures that each number code moves with its corresponding item description.
Sort linked worksheet data in WPS Spreadsheets

Alphabetize Items While Keeping Codes Together in WPS Spreadsheets

WPS Spreadsheets lets you sort a complete data range by item description so every number code and related field stays on the same row. Its familiar spreadsheet interface makes it easy to sort Excel-style tables without breaking record relationships.

  1. 1. Select the related data range: In WPS Spreadsheets, select all columns that belong to the item records, such as the description and number-code columns.
  2. 2. Open the sort command: Click Data on the ribbon and choose Sort.
  3. 3. Choose the item-description field: In the Sort dialog, select the Item Description column as the sort key and choose Ascending.
  4. 4. Confirm the full-range sort: Make sure the selected range includes all linked columns, then click OK to sort the rows together.
Sort complete rows alphabetically by an item-description column.Keep assigned number codes paired with their original items.Open, edit, and save Microsoft Excel .xlsx and .xls files.Use a familiar, lightweight spreadsheet interface for everyday data tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my number codes no longer match the item descriptions after sorting?

This usually happens when only one column was sorted. Undo the action if possible, then select the entire related range and sort by the Item Description column.

What should I choose when Excel asks whether to expand the selection?

Choose Expand the selection. This option includes the adjacent columns so the codes, descriptions, and other row data move together.

Can I sort a table with a header row alphabetically?

Yes. Select the whole table, go to Data > Sort, select My data has headers, choose the Item Description column, and set the order to A to Z.

Should I sort the number-code column by itself?

No. Sorting the number-code column alone separates it from its matching description. Always include all columns that belong to the same item record.