Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index



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+help@global.libreoffice.org wrote:
Subject:
[libreoffice-users] Nested Drop-down List
From:
"Vince@Verizon" <wa.tworsx@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+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.