INDEPENDENT SOFTWARE JOURNAL
TrebuchetJOURNAL
EST. 2026 · DIGITAL EDITIONExplore guides
LIBREOFFICE · CALC · HOW-TO GUIDE

Sorting and Filtering Data in LibreOffice Calc Without Losing Rows

Filter records and sort tables without separating a value from the row it belongs to.

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.

  1. Step 1. Prepare a tidy table with a single header row and no blank rows splitting the records.
  2. Step 2. Enable AutoFilter on the table and filter a Category or Status column.
  3. Step 3. Choose a sort order and confirm that the selected range includes every related column.
  4. Step 4. Remove the filter and verify that the row count and key values remain intact.
  5. Step 5. Save a separate copy before trying more complicated multi-column sorts on important data.

Worked example you can recreate

Try this on a sample file

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.