Data Import & Export

Keep Notes Aligned When Sorting Excel Rows by Date

Jason MillerJason Miller Nov 18, 2026 869 views

Question details

Keep incident notes associated with their corresponding dates and values when sorting an Excel list.

Keep Notes Aligned When Sorting Excel Rows by Date
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants to sort an incident list by date without separating notes from the related records.
Observed behavior
Notes may become separated from their related dates and values if only part of the list is sorted.
Before you start

Make sure each incident's date, value, and note are in the same row, with a header for each column. If notes have already become misaligned, identify and correct their row associations before sorting.

Solution 1Recommended

Convert the Full List to an Excel Table and Sort by Date

Use an Excel Table to keep each row together when sorting the date column.

1
Select the full list

Select all columns in the list, including dates, values, notes, and their headers.

2
Create a table

Choose Insert > Table, confirm the selected range, check My table has headers if applicable, and select OK.

3
Sort the dates

Open the filter arrow in the date column header and choose Sort Oldest to Newest or Sort Newest to Oldest.

4
Check the records

Review several sorted rows to confirm that each note still matches its date and value.

Convert the Full List to an Excel Table and Sort by Date
Check cell comments separately: If incident notes are stored as cell comments or threaded comments rather than cell values, verify after sorting that the comments remain attached to the intended cells.
Sort complete rows in WPS

Keep Incident Notes Together in WPS Spreadsheets

Open your workbook in WPS Spreadsheets and sort the complete data range by date so each note stays with its related row.

  1. 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select your Excel workbook.
  2. 2. Select the full list: Select the entire data range, including the date, value, and note columns and their headers.
  3. 3. Sort by date: Choose Data > Sort, select the date column, and choose the desired ascending or descending order. If prompted, expand the selection to include the related columns.
  4. 4. Verify and save: Check that notes match their dates and values, then choose File > Save or Save As.
Sort dates while keeping related values and notes in the same rowOpen and edit Microsoft Excel XLS and XLSX filesUse familiar spreadsheet tools to review and organize incident lists
QA img-9

Frequently Asked Questions

Why did my notes move away from the correct dates?

This can happen if only the date column or another part of the list was sorted. Select the complete range before using Data > Sort so the related cells move together.

Should I choose Expand the selection when Excel asks?

Yes, if the adjacent columns contain data belonging to the same records. Choose Expand the selection so Excel includes those columns in the sort.

Will converting my list to a table fix notes that are already misaligned?

No. Correct the associations first using the original records or another reliable identifier, then select the full list and choose Insert > Table.

What if my notes are stored as Excel comments?

After sorting, inspect the cells with comments or threaded comments to verify that each comment is attached to the intended record. Notes stored as cell values in the same row can be included in the sorted range.