Data Import & Export

How to Sort an Entire WPS Excel Spreadsheet by Maturity Date

Huma Ashraf ChHuma Ashraf Ch Nov 13, 2026 870 views

Question details

The user wants to sort all worksheet records by the maturity-date column while keeping each date attached to its related row data.

How to Sort an Entire WPS Excel Spreadsheet by Maturity Date
Product
WPS Spreadsheets
Device & OS
not provided
Scenario
The user has a worksheet with maturity-date records and needs the entire dataset ordered by that date without splitting rows.
Observed behavior
The desired state is a worksheet sorted by maturity date with all related row data preserved.
Before you start

Before sorting, select the entire worksheet range or convert it to a table so every column moves with the maturity-date records. Also confirm the maturity-date cells are real date values and not text by selecting the column and checking the Number Format on the Home tab.

Solution 1Recommended

Use Data Sort on the Entire Data Range

Use this method when the worksheet is a regular data range and all columns in the current region need to stay together while sorting by maturity date.

1
Select the entire data range

Click any cell inside the dataset, then press Ctrl+A or drag to select all columns and rows that must stay together, including the header row.

2
Open Data Sort

Go to the Data tab in the WPS Spreadsheets ribbon and click Sort.

3
Choose the maturity-date column

In the Sort dialog, select the maturity-date column from the Sort by drop-down. If the range has a header row, tick My data has headers.

4
Set the date order and apply

Choose Oldest to Newest or Newest to Oldest as needed, confirm Sort On is Cell Values, and click OK.

Use Data Sort on the Entire Data Range
Rows stay aligned: All rows are reordered by maturity date while related data remains intact.
WPS Spreadsheets

Sort an Excel Spreadsheet by Maturity Date in WPS Office

Open your Excel workbook in WPS Office Spreadsheets, select the full data range or table, and use Data > Sort to order all records by the maturity-date column without splitting rows.

  1. 1. Open the Excel workbook in WPS Spreadsheets: Launch WPS Office, click File > Open, and choose the Excel workbook that contains the maturity-date records.
  2. 2. Select the full data range: Click anywhere in the dataset and press Ctrl+A, or convert the range to a table from Insert > Table.
  3. 3. Open Data Sort: Go to the Data tab and click Sort.
  4. 4. Sort by the maturity-date column: In the Sort dialog, set Sort by to the maturity-date field, select the date order, and click OK.
  5. 5. Save the sorted workbook: Click File > Save or Save As to keep the sorted workbook in .xlsx or .xls format for Microsoft Excel compatibility.
Sorts entire rows by maturity date so related data stays alignedOpens, edits, and saves Microsoft Excel .xlsx and .xls files with full compatibilityFree Office suite with a familiar ribbon interface for easy migrationLightweight and fast for everyday spreadsheet tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why do my rows get misaligned when I sort only the date column?

Because sorting only the maturity-date column changes the order of dates but leaves the other columns in place. Select the entire range or convert the data to a table before sorting in WPS Spreadsheets.

How do I check if my maturity dates are stored as text instead of real dates?

Select the date cells and look at the Number Format box on the Home tab. If it does not show Date, or if dates align left with an apostrophe, they may be stored as text. Change the format to Date or re-enter the values with a proper date format.

Can I sort by maturity date in oldest to newest order in WPS Office?

Yes. In the Sort dialog, choose the maturity-date column, set Sort On to Cell Values, and choose Oldest to Newest under Order.

How do I make the sort range include new rows automatically?

Convert the range to a table by selecting the data, going to Insert > Table, and checking My table has headers. The table range expands automatically when new rows are added.

Does WPS Spreadsheets keep the Excel file format after sorting?

Yes. Use File > Save or Save As to save the workbook as .xlsx or .xls so it remains compatible with Microsoft Excel.