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.
Mike
On 5/21/22 15:07, users+h...@global.libreoffice.org wrote:
Subject:
[libreoffice-users] Nested Drop-down List
From:
"Vince@Verizon" <wa.two...@verizon.net>
Date:
5/21/22, 12:40
To:
users@global.libreoffice.org
Hi:
Hope that all are well.
I am using LO 7.3.2.2 (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.
VinceB.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
