Data Import & Export

Excel: Alphabetize Product Names While Keeping PLUs Matched

Huma Ashraf ChHuma Ashraf Ch Nov 12, 2026 869 views

Question details

Alphabetize product names while ensuring every PLU code remains paired with its original product.

Alphabetize Excel Product Names While Keeping PLUs Matched
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.
Before you start

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.

Solution 1Recommended

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.

1
Place the lists together

Move or copy the product names and their matching PLU codes into adjacent columns, with each matching pair on the same row.

2
Select both columns

Click and drag to select the entire Product and PLU range, including all rows that must stay paired.

3
Open the Sort dialog

On the Excel ribbon, select Data > Sort.

4
Sort by product name

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.

Sort the complete product and PLU range in Excel
Product and PLU pairs stay intact: Because both columns are included in the sort selection, each PLU moves with its corresponding product.
WPS Spreadsheets

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. 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. 2. Select the data range: Drag to select both the Product and PLU columns, including every row you want to sort.
  3. 3. Open the sorting tool: Select the Data tab, then click Sort.
  4. 4. Set alphabetical order: Choose the Product column as the sort key and select ascending order, A to Z.
  5. 5. Apply the sort: Confirm the selected range includes both columns, then click OK to reorder the product rows with their PLUs.
Sort product names from A to Z while retaining matching PLU codesOpen, edit, and save Microsoft Excel .xlsx and .xls filesUse a familiar Data tab and Sort dialog for spreadsheet organizationWork with a free, lightweight office suite
QA img-9

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.