Excel: Alphabetize Product Names While Keeping PLUs Matched
Question details
Alphabetize product names while ensuring every PLU code remains paired with its original product.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user has product names and PLU codes in separate columns and wants to sort the product list alphabetically.
- Observed behavior
- The full product-and-PLU range needs to move together during the alphabetical sort, rather than sorting either column independently.
Make sure each product name and its PLU are on the same row in one continuous two-column range. Include the header row only if your list has column headings such as Product and PLU.
Sort the complete product and PLU range in Excel
Use this method to alphabetize products while preserving the PLU assigned to each product.
Select both columns before sorting so Excel moves complete rows instead of rearranging the product names and PLUs separately.
Move or copy the product names and their matching PLU codes into adjacent columns, with each matching pair on the same row.
Click and drag to select the entire Product and PLU range, including all rows that must stay paired.
On the Excel ribbon, select Data > Sort.
In the Sort dialog, choose the Product column under Sort by, select Values, and set Order to A to Z. If prompted, choose Expand the selection, then select OK.

Convert the list to an Excel table before sorting
Use this option when the list is regularly updated and you want Excel to recognize the full data range automatically.
Sort Product Names and Matching PLUs in WPS Spreadsheets
WPS Spreadsheets lets you sort a combined Product and PLU range alphabetically while keeping each code on the same row as its product. Its familiar spreadsheet layout makes it easy to work with existing Excel lists.
- 1. Combine the columns: In WPS Spreadsheets, place Product and PLU in adjacent columns and verify that each product-code pair is on one row.
- 2. Select the data range: Drag to select both the Product and PLU columns, including every row you want to sort.
- 3. Open the sorting tool: Select the Data tab, then click Sort.
- 4. Set alphabetical order: Choose the Product column as the sort key and select ascending order, A to Z.
- 5. Apply the sort: Confirm the selected range includes both columns, then click OK to reorder the product rows with their PLUs.

Frequently Asked Questions
Why do PLU codes no longer match the correct products after sorting?
This happens when only one column is sorted. Undo the sort if possible, then select the entire Product and PLU range before using Data > Sort.
What should I choose when Excel asks whether to expand the selection?
Choose Expand the selection so Excel includes the PLU column and moves each complete product row together.
Can I sort products alphabetically if the PLU is stored in a different column?
Yes. Select all columns containing related information for the same rows, then use Data > Sort and sort by the Product column from A to Z.
Should I sort the header row with the product data?
If your range has headers, include them in the selection and indicate that the data has headers in the Sort dialog. Excel will keep the header row at the top.




