Filter records and sort tables without separating a value from the row it belongs to. This tutorial focuses on a repeatable real-world task you can test on a sample file, not an unverified performance claim. LibreOffice is a desktop office suite; application menus and options may differ by operating system and release.
How to do it: a practical workflow
Work on a copy of your files when learning a new application. The sequence below gives you a testable outcome and a way to verify the result.
- Step 1. Prepare a tidy table with a single header row and no blank rows splitting the records.
- Step 2. Enable AutoFilter on the table and filter a Category or Status column.
- Step 3. Choose a sort order and confirm that the selected range includes every related column.
- Step 4. Remove the filter and verify that the row count and key values remain intact.
- Step 5. Save a separate copy before trying more complicated multi-column sorts on important data.
Worked example you can recreate
In a supplier list, filter Status to Pending and sort by DueDate ascending. Each row must keep the supplier name, balance and date together; sorting only the DueDate column would corrupt the relationship.
Common problems and what to verify
Blank rows and mixed data types can cause only part of a table to be filtered or sorted. Clean the source first.
Before handing a document to someone else, open the output in the format that person will use. Check the content and key calculations rather than relying on an export-success notification.
Quick answer
Does filtering delete hidden rows?
No. Filtering normally hides nonmatching rows in the current view; it does not delete the underlying records.
Official reference and download
These instructions draw on documentation from The Document Foundation. For current user-interface details, refer to the official guide for this topic ↗. Download installation files only from LibreOffice's official download page ↗.
Keep learning
Each of these related guides answers a different task, so you can move from basic setup to a more specific workflow without repeating the same overview.
Independent educational coverage. Trebuchet is not affiliated with or endorsed by The Document Foundation. This article describes documented workflows and illustrative examples; it is not a report of hands-on benchmarking or testing.
