This is a picture of example. For example, how to show only rows that contain "A"?
and can I show only rows that contain "A" or "B"? (i.e. both are shown)
[Solved] Show only desired rows
[Solved] Show only desired rows
- Attachments
-
- exampl.jpg (49.52 KiB) Viewed 680 times
Last edited by MrProgrammer on Sun Dec 18, 2022 7:53 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Openoffice 4.1.8 and unspecified version of LibreOffice
Re: How to show only desired rows?
You can do this using the menu item Data -> Filter. To select for a single value, you can use the AutoFilter. For multiple conditions, use the Standard Filter. Start with the cursor at the top of the cell range you want to filter and have a heading there if possible.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.