Sort, Filter, and Hide Data

---

Sort Data

There are two ways to sort data:

1. Sort entire rows and columns
2. Sort only selected cells

Sort entire rows and columns

Data can be sorted either by columns or rows, either ascending or descending. It sorts based on the data in the main selected row or column. The headers won't be sorted.

Sorting does work in read-only mode.

Double-click on the row or column labels.
Sort Selected [Row|Column]- Ascending
Sort Selected [Row|Column]- Descending

ctrl+z undoes a sorting operation.

Sort only selected cells

The following commands sort only the data in the selected cells. No data outside the selection will be affected.

Sort Selected Cells Horizontally - Ascending
Sort Selected Cells Horizontally - Descending
Sort Selected Cells Vertically - Ascending
Sort Selected Cells Vertically - Descending

---

Filtering Data

Data can be filtered, either by rows or columns. That means it only keeps columns or rows that pass the filter criteria. The headers won't be filtered.

Windows/LinuxmacOS

Filtering is subject to the undo and redo commands (ctrl+z and ctrl+y). However, it will not change the underlying data when you save the file.

Filtering is subject to the undo and redo commands (cmd+z and cmd+y). However, it will not change the underlying data when you save the file.

To delete the filtered out data, use the Remove All Filtered Out and Hidden Data command. To save the filtered in data (i.e. what's shown on the table) into a separate file, use the Save Visible Data As command.

Filtering does work in read-only mode.

All the following filter commands will be made available to you if you click the "Filters" portion of the status bar:

Adding filters

Add Filter
Filter Selected [Row|Column]
Filter Selected [Row|Column](s) with Selected Cell Contents

The Filter Selected [Row|Column](s) with Selected Cell Contents commands will filter multiple values if you select multiple values. It can also simultaneously filter several columns or rows if you select several columns or rows.

Viewing and editing filters

View/Edit Filter(s)

Removing filters

Remove Individual Filter(s)
The Remove All Filters command removes all filters.

Filter Syntax

When you add or edit a filter, the program gives you filter syntax instructions. They are repeated here:

Operator	Meaning	Examples
*	Wildcard	abc* matches abcdef
| and &	OR and AND	*abc*&*def*|*ghi matches def123abc or ghi but not abc or def.
!	NOT (exclude from search)	!*abc* matches def but not abcdef.
< and >	LESS THAN and GREATER THAN	<50 matches 30, but not 70.
<= and >=	LESS THAN OR EQUAL and GREATER THAN OR EQUAL	50+ matches 50 and 70, but not 30
+ and - (after a number)	LESS THAN OR EQUAL or GREATER THAN OR EQUAL (alternative)	50+ matches 50 and 70, but not 30.
#	Regular Expression signifier	#[1-9]\d{3,4}(\.\d+)?
- (between two numbers)	BETWEEN (inclusive)	0-10 matches 0, 4.2, and 10, but not 12 or -3.
\	Escape character	\\, \*, \|, \&, \<, \>, \+, \-, or \#.

Matching is case insensitive except for regular expressions. Spaces before and after filter strings are ignored.

If you use # for regular expressions, it must be the first character. All the other syntax rules will be ignored. You only need to escape it if # happens to be the first character of your filter phrase.

---

Hiding and Showing Data

You can hide rows or columns without deleting the data. Use one of the following commands:

Hide Selected Row(s)
Hide Selected Column(s)
Hide All But Selected Row(s)
Hide All But Selected Column(s)
Hide Empty Row(s)
Hide Empty Column(s)

Hide Empty Row(s) and Hide Empty Column(s) do not require the headers to be empty.

To show the hidden rows/columns again, use the following commands:

Show Hidden Row(s) in Selection
Show Hidden Column(s) in Selection
Show Empty Row(s)
Show Empty Column(s)
Show All Hidden Row(s)
Show All Hidden Column(s)

For the Show Hidden Row(s)/Column(s) in Selection commands, you have to select the surrounding rows/columns first. For instance, if you hide column 3 and want to show it again, select columns 2 and 4, then call the Show Hidden Column(s) command.

To delete the hidden data, use the Remove All Filtered Out and Hidden Data command. To save the shown data (i.e. what's not hidden) into a separate file, use the Save Visible Data As command.