Are you familiar with Auto Filter?
Highlight all column headers and all the data below -
then select Data - Autofilter.
Is that what you want?
You can set multiple filter criteria in the column header drop-downs.
Select Data - Autofilter again to turn it off, if you want it off.
On 5/21/22 15:07, firstname.lastname@example.org wrote:
[libreoffice-users] Nested Drop-down List
Hope that all are well.
I am using LO 220.127.116.11 (x64) on desktop Win10 Home.
I want to fine tune a LO Calc file by adding a column that includes a
Category drop-down menu, but I find that I might have need for
subcategories, in some cases, to avoid a very long list of items.
I recall viewing a tutorial about what I am calling "nested drop-down
menu list", whereby if an option in the parent drop-down is selected,
a second, a third, ... etc. drop-down list is then opened, if they
exist. For example, if one option is utilities, a second drop-down is
opened showing, e.g. telephone, electricity, heating fuel, water,
etc., as further, optional, selections.
Unfortunately, I cannot recall if the tutorial was for Excel or Apache
Open Office or Libre Office.
Can somebody point me to a */Libre Office/* video tutorial or within
the LO Help that covers "nested drop down list"? "Nested drop-down
menu list" is most probably an incorrect key word text string.
Thanks for reading this.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- Re: [libreoffice-users] Nested Drop-down List · Mike Flannigan
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy