SoftMaker PlanMaker · Sorting and filtering · Intermediate
Sort PlanMaker Records by Multiple Keys
Reorder complete records by region and amount, preserve identity and restore original order in a documented FreeOffice 2024 six-record sort; use the separate paid PlanMaker 2026 workflow to include new rows and check saved files.
FreeOffice 2024 sorting documentation and retained paid 2026 workflow reviewed; native execution, exact installed build and save/reopen acceptance pending · Editorial standards
Sort a complete record range when the source itself must be reorganized. The worksheet Sort command is different from producing a separate formula result. An explicit sequence column makes the operation reversible even after the file has been closed.
Choose the branch for your edition after entering the shared fixture. The FreeOffice 2024 branch below covers only the six-record value sort, changed key and restoration. The later seven-record and saved-file workflow retains its separate paid PlanMaker 2026 scope; it is not blanket FreeOffice guidance.
Enter a complete record fixture
Enter this block in A1:F7. Amounts and sequence numbers are numeric; no rows are hidden and no filter is active in this new practice workbook.
| Sequence | Order | Region | Product | Amount | Status |
|---|---|---|---|---|---|
| 1 | 1001 | East | Cable | 120 | Open |
| 2 | 1002 | West | Adapter | 85 | Closed |
| 3 | 1003 | East | Stand | 160 | Open |
| 4 | 1004 | North | Cable | 95 | Open |
| 5 | 1005 | West | Hub | 140 | Closed |
| 6 | 1006 | North | Adapter | 70 | Open |
The six amounts total 670. Treat each complete row as one record; matching totals alone cannot detect fields attached to the wrong Order.
FreeOffice 2024: six-record sort and restoration
Use only the six records above in a fresh disposable practice workbook, with every row visible and no active filter. This branch is based on the FreeOffice 2024 manual, printed pages 96–100, not an installed-build test. It does not extend the later paid workflow to FreeOffice. If your English ribbon controls differ, stop and record your edition/build rather than guessing a substitute.
- Select the entire A1:F7, never just the key columns. Open Data → Filter → Sort.
- Choose Sort row by row and enable First row contains headings. For criterion 1, set Column to C (Region) and Order to Ascending. For criterion 2, use E (Amount), Descending. Confirm with OK. These labels and the combined-key dialog are documented on printed pages 97–99; do not replace the combined specification with separate quick sorts.
- Expect B2:B7 to be 1003, 1001, 1004, 1006, 1005, 1002, with the headings still in row 1 and total 670. For every Order, compare all five other fields with the fixture. In particular, Order 1003 must remain Sequence 3 / East / Stand / 160 / Open.
- Locate Order 1001 by its identifier and change only its Amount from 120 to 180. Rerun the same full-range, two-key sort. Expect 1001, 1003, 1004, 1006, 1005, 1002 and total 730. Other fields and records must be unchanged.
- To restore entry order, select A1:F7 again and reopen the same dialog. Keep the row orientation and heading option; change criterion 1 to column A (Sequence), Ascending, then confirm. Sequence is unique here, so lower-priority criteria cannot change that order. Expect Orders 1001, 1002, 1003, 1004, 1005, 1006; the total is still 730, because sorting does not undo the amount edit.
- Restore Order 1001’s Amount to 120. Compare all six complete records with the original table: the order and field values should now match exactly, and the total should be 670. Do not edit Sequence to manufacture this result.
These are independently checked fixture expectations, not observed application results. This branch ends with restoration of the six-record fixture; it does not add row 8 or use the paid workflow’s filenames. Native execution, exact installed-build matching and save/reopen persistence remain pending. Do not treat an on-screen match as proof of a saved result.
Paid PlanMaker 2026: retained saved-file workflow
The following extended rehearsal retains the paid 2026 documentation scope. Start again from the original six-record fixture above, with Order 1001 at 120; do not carry a changed amount into this baseline.
Save orders-before-sort.pmdx, then save a working copy as orders-sorted.pmdx. The six amounts total 670. Record identity includes all six fields, not merely the order number.
Sort region ascending, amount descending
- Select A1:F7, including every field and the heading row. Do not select only Region or Amount.
- Choose Data → Filter → Sort. The manual also places these commands under Home → Contents → Sort and filter.
- Choose Sort row by row, since each record occupies one row. Enable First row contains headings.
- For criterion 1, choose column C (Region), with Ascending order. For criterion 2, choose column E (Amount), with Descending order. Do not substitute two separate quick sorts for this combined specification.
- Confirm. Verify headings still occupy row 1.
The expected Order sequence in B2:B7 is 1003, 1001, 1004, 1006, 1005, 1002. Regions run East, East, North, North, West, West. Within each pair, amounts decrease: 160 then 120; 95 then 70; 140 then 85. Order 1003 must still say Stand, 160, Open and Sequence 3. The total remains 670.
A quick Ascending command on a multicolumn selection sorts by that selection’s leftmost column. Here that would be Sequence, so use the dialog to select Region explicitly.
Change a key and grow the range
Find Order 1001 by its identifier, not its original row position. Change its Amount from 120 to 180. Sorting is an operation, not a live view: run the same two-key sort again. Expected order becomes 1001, 1003, 1004, 1006, 1005, 1002, and the total becomes 730.
Append row 8 as 7 | 1007 | East | Dock | 160 | Open. Select A1:F8 and rerun the sort. Add criterion 3, Order (column B), Ascending, to specify what happens when amounts tie. Expected order is 1001, 1003, 1007, 1004, 1006, 1005, 1002; total 890. Sequence values remain 1, 3, 7, 4, 6, 5, 2 in that displayed order. This third key avoids relying on an undocumented tie-stability assumption.
Advanced: hidden records and formatting
Before sorting an existing report, inspect whether rows are hidden. The dialog’s Include hidden cells option controls their inclusion; hidden cells normally do not participate. For a whole-dataset sort, make all records visible first, verify the complete range, and explicitly inspect that option. Do not assume hiding a filter’s controls has restored its records. This exercise starts on a clean, fully visible range to avoid that ambiguity.
Sort including borders/shading decides whether these formats move with the cells or stay at their original positions. Choose intentionally: a colored record flag belongs with the record, while a fixed page-layout band may not. Color sorting is separately available, but this numeric exercise uses values only.
Save and reopen the intended final result
Keep the seven-row advanced result with Order 1001 at 180 and Order 1007 at 160. Save orders-sorted.pmdx, close and reopen it. Recheck the order 1001, 1003, 1007, 1004, 1006, 1005, 1002, the 890 total and Order 1007’s Dock/160/Open fields. This catches a partial-column sort that might otherwise look plausible.
Optional reset on a separate copy
Only after verifying that final file, use File → Save as to create orders-reset-practice.pmdx. In this separate copy, sort the full range by Sequence ascending, with headings excluded, to restore entry order. Do not edit Sequence itself. Restore Order 1001 to 120 if you also want its original value; the seven-row total then becomes 830, not the final file’s 890. To recover the original six-row fixture exactly, open the preserved orders-before-sort.pmdx instead. Do not overwrite orders-sorted.pmdx or depend on Undo after reopening.
Troubleshooting
- Heading moves: restore the saved copy and enable First row contains headings.
- Region is right but amounts are not: inspect criterion 2 and its independent direction.
- Numbers sort oddly: correct imported text amounts before rerunning.
- New record stays at the bottom: extend the selected rectangle to include it.
Use AutoFilter when you want to hide nonmatching records rather than rearrange them.
Version and verification notes
FreeOffice 2024 six-record sort/edit/restore branch plus retained PlanMaker 2026 paid desktop workflow for Windows, macOS and Linux; documentation-qualified English ribbon instructions, not native application verification. NX builds require matching controls; mobile editions and blanket FreeOffice parity are not established. These steps use the English ribbon labels; classic-menu placement is not assumed to match. Documented context-menu or alternate ribbon routes are included where verified.
The retained paid instructions were checked against SoftMaker’s PlanMaker 2026 manual; the new free branch was separately checked against the complete sorting section of the FreeOffice 2024 manual. Expected orders, totals and full-record restoration are independently checked reference results, not observations from a native application run. No current application screenshot is claimed. No exact installed-build match or save/reopen acceptance is established for either branch.